Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to share a Data Flow from another Workspace, so I did the following:
One of the users who has access to the new Workspace wanted to connect to this Data Flow.
They opened Power BI Desktop > Get Data > Dataflows > On the Navigator page but unable to see the dataflow, they can see the Workspace and other Dataflows in this Workspace but not the linked one?
I am assuming it is because they do not have access to the Workspace that I am using the Linked Service to?
The reason I cannot give them access to the original Workspace because there is secured data on there, the dataflow I wanted them to have accss to is a trimmed down version which excludes some of the secured fields.
What is the best option now?
Thanks
Solved! Go to Solution.
You are correct in that for linked tables, they need access to the source. What you can do in the same dataflow with the linked tables, is create a reference to the linked table (right click on the linked table and select reference). This creates a computed table. You can then add additional transformations in the computed table or leave as is. Save the changes, and make sure you refresh and setup a schedued refresh for this dataflow. Your users should now see the computed tables in the dataflow.
You are correct in that for linked tables, they need access to the source. What you can do in the same dataflow with the linked tables, is create a reference to the linked table (right click on the linked table and select reference). This creates a computed table. You can then add additional transformations in the computed table or leave as is. Save the changes, and make sure you refresh and setup a schedued refresh for this dataflow. Your users should now see the computed tables in the dataflow.
Hi @blopez11 Thanks for this.
This seems to have done the trick, just to confirm there is no way the user can amend the dataflow and somehow add fields if they manage to amend this dataflow; we have tried to at our end and users are unable to Take over the Dataflow well they can Takeover but they cannot sign in as their Authentication fails.
But trying to look at different scenarios if there is posibilities of a user extracting fields they shouldn't be allowed to see.
Thanks
If you just give your consumers the viewer role on the workspace where the dataflow exists, they should not be able to modify anything in the workspace. Glad to hear it worked.
@blopez11 I haven't given them any role to the workspace where the original Dataflow exisits, and it still works; so good work!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
20 | |
19 | |
18 | |
9 |