Good afternoon,
I am attempting to use a single Dataset for multiple Workspaces.
The idea is to create one go-to Dataset with a fairly comprehensive model, and use that one dataset for multiple workspaces so that I can publish three apps for different user groups.
I was able to create a new workspace with a linked dataset from another workspace. However, I can’t figure out how to publish reports into this workspace. I create a new pbix file and connect to the existing published dataset. However, when I click Publish, it doesn’t give me an option for which workspace to publish to - it always publishes to the dataset’s home workspace.
I want to create pbix files that publish to the workspace of my choice. That workspace has a linked dataset.
I know it is possible to just copy the dataset and publish to a new workspace, however, that means I have three different data refreshes of the same data. This seems like unnecessary load on the database.
Resources: https://docs.microsoft.com/en-us/power-bi/service-datasets-across-workspaces
http://connollyconsultants.com/2017/11/power-bi-tips-one-dataset-to-rule-them-all/