Forum Discussion
Issue with Sharing Linked Dataflows in Power BI
- 1 year ago
Hi Hazzzy
Welcome to the Microsoft Fabric Community.
The issue occurs because linked dataflows in Power BI depend on the permissions of the original dataflow. If users in the new workspace don't have access to the original workspace, they cannot access the linked dataflow.
Grant Viewer Access to the Original Workspace:- Provide the users with Viewer permissions in the original workspace containing the source dataflow. This will enable them to access the linked dataflow through the new workspace.
Create a Separate Dataflow:
- Instead of using a linked dataflow, create a new dataflow in the new workspace by importing data directly from the SharePoint folder or exporting and importing the original dataflow definition.
Use Shared Datasets:
- Publish a shared dataset from the original dataflow. Share the dataset in the new workspace without linking the dataflow. This ensures that users can access the processed data without requiring access to the original workspace.
Service Principal and Security Groups:
- Use a service principal with permissions to access the source dataflow and configure it in the linked dataflow. Ensure the service principal handles dataflow dependencies securely.
-
Direct Data Export:
- Export the data from the source dataflow to a new storage location (e.g., Azure Blob Storage, another SharePoint folder) and create a new dataflow in the new workspace to source data from there.
If the above information helps you, please give us a Kudos and marked the reply as a solution.
Thanks,
Cheri Srikanth
The users need access to the workspace that holds the actual dataflows. If you are concerned about giving them access to the other content in that workspace then move that other content somewhere else.
Thank you, Ibendlin. This approach could work, but it would require creating and maintaining user access for many workspaces. This adds a lot of extra work, which I would like to avoid. Is there a more efficient way to achieve this?
- lbendlin1 year agoSuper User
Consider Occam's Razor. Dataflows are additional steps. If you can avoid them, don't use them at all.