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
Hi Hazzzy
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please accept as solution to help others benefit. If not, feel free to reach out.
Feel free to reach out if you need any further assistance.
We look forward to your update!
Thank you,
Cheri Srikanth.