Connect to Power BI service dataset in a different workspace
The new feature that enable to connect to datasets published on Power BI is great, but right now you can connect only to datasets published in the same workspace.
The need is to connect to datasets published in different workspaces.
Real world scenario:
- 1 workspace where I publish the dataset
- many app workspaces that connect to the published dataset
This would avoid the need to publish and mantain the same dataset in several app workspaces.
Kevin H commented
This has been delivered and should be marked complete.
What is the status here? Any developments planned?
Jack Strudley commented
This is needed for both Datasets and Dataflows in Pro. We want one version of the truth. I want to be able to create a Dataflow for example in a Data Workspace and then build reports from that same Dataflow and publish them to customer workspaces.
How to publish Power BI reports to different workspace that are built on Power BI datasets
Can you please let us know , is there any way that we can share a Power BI data set with users, and users can build and publish reports to any workspace (and users need not have update/delete permissions on power bi dataset).
With current Power BI workspace permissions, a person can be either read/write all power bi content (including dataset, report, dashboard,etc) based on workspace permissions, but there is no way that user can have granular permission levels at each component (dataset/report/dashboard)
e.g.: Read permission at dataset level, write permission to workspace to build and publish reports from that data set.
We trying to find a solution for the following scenario
• Data engineers build a dataset , publish to power BI, and it will be shared to multiple users
• Business users/analysts should be able to read this power bi data set (Get Data --> Power BI Dataset connector)
• Business users/analysts should be able to build reports and deploy reports to any workspaces.
Andrew Simmans commented
Whilst the golden dataset approach described below helps. The big problem I have is that it takes some time to refresh the dataset and really what we want to do is have one dataset that is refreshed once each night and then can be used in multiple apps / workgroups. The content packs tried to do this but I understand the use of these is now discouraged. Also with the content packs you then had to take a copy of the dataset to write a new report for the App workspace which I do not want to do. I want the users to all use the one dataset and pick up changes / refreshed data as they happen.
jerry deng commented
Our way of re-using one golden dataset across different apps, as I commented on one of Matt Arlington's blogs:
In my scenario I am making this Golden Dataset available to use in multiple App Workspaces, to maximize the application of “single source of truth”. This is done by using Sharepoint to house the Golden Dataset (PBIX), then in each of the App Workspaces use Get Data –> Get Files –> Sharepoint Teamsites, then point to where the PBIX file is uploaded.
The setup is pretty straightforward, using Sharepoint as the cloud storage for PBIX files, and by using the "Get Files from Sharepoint" method above, in each App Workspace, the Golden Dataset is now available for use in each App Workspace, and subsequently production Apps. Future updates in the Golden Dataset (data refresh, measures, relationships) will reflect to each App Workspace.
This would help with securing datasets in that it would allow members to create and edit reports in another workspace but prevent them from randomly refreshing or overwriting the dataset. You can do this now with organization content packs but in a clunky way.