cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tcash Frequent Visitor
Frequent Visitor

Read access to a Dataflow as a data source by a non-owner of the dataflow

How do I enable a PBI desktop user to read PBI service dataflow entities when the user is not the one that created the dataflow?  Note, the Dataflow is created in a Workspace that is using Azure Data Lake Gen2 storage.

 

Currently, the user opens PBI Desktop, does Get Data, Power BI Dataflows and is displayed a list of all dataflows and their  entities.  However, when an entity is checked for selection as a data source the user gets the message "Expression.Error: Access to the resource is forbidden."

 

Regards,

Tim

1 ACCEPTED SOLUTION

Accepted Solutions
tcash Frequent Visitor
Frequent Visitor

Re: Read access to a Dataflow as a data source by a non-owner of the dataflow

I believe our permission issues are caused by the fact that we are writing to a tenant based Azure Data Lake Gen2 storage filesystem (as opposed to the default shared Data Lake filesystem).  We need to manually assign permissions to all of our Data Lakes CDM folders and files.  It is  tedious for now because the permissions do not propagate to files that already existed before new permissions are applied.  The Data Lake permission propagation rules are still not clear to me but we finally got things to work "good enough" after much manual tweaking and testing. Hopefully, this manual effort is eliminated or minimized after PBI dataflows get out of preview mode. In the meantime the manual effort can be minimized by knowing the GUIDs of all security groups needing access to individual folders and their files soon after the CDM folders are created by a refresh.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Read access to a Dataflow as a data source by a non-owner of the dataflow

hi, @tcash 

I have test on my side, it works well.

User A create a data flow in a workspace, and User B could get data in power bi desktop from this data flow.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tcash Frequent Visitor
Frequent Visitor

Re: Read access to a Dataflow as a data source by a non-owner of the dataflow

I believe our permission issues are caused by the fact that we are writing to a tenant based Azure Data Lake Gen2 storage filesystem (as opposed to the default shared Data Lake filesystem).  We need to manually assign permissions to all of our Data Lakes CDM folders and files.  It is  tedious for now because the permissions do not propagate to files that already existed before new permissions are applied.  The Data Lake permission propagation rules are still not clear to me but we finally got things to work "good enough" after much manual tweaking and testing. Hopefully, this manual effort is eliminated or minimized after PBI dataflows get out of preview mode. In the meantime the manual effort can be minimized by knowing the GUIDs of all security groups needing access to individual folders and their files soon after the CDM folders are created by a refresh.

Community Support Team
Community Support Team

Re: Read access to a Dataflow as a data source by a non-owner of the dataflow

hi, @tcash 

Great! It's pleasant that it works "good enough".

If you consider this issue closed, please mark it as "solved", that way, other community members will easily find the solution when they get same issue.  Smiley Very Happy

Thanks.

 

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 28 members 859 guests
Please welcome our newest community members: