Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
kkozmic
Frequent Visitor

Increase security of DataFlow

Hello everyone!

I wanted to share report with my colleagues. In order to do that I gave them permissions to that report and semantic model, which is the source of data for this report (when I gave them access only to the report, they've had errors and could not see the data). They have only "Read" access to the report and semantic model. The semantic model also contains some DataFlows. The problem is that they can still open Power Query in Power BI Desktop and access to that DataFlows, which I don't want. How to take away their permission, so they cannot access the DataFlows?

1 ACCEPTED SOLUTION
kkozmic
Frequent Visitor

Thanks for the advice, but I fixed the problem by myself. The problem was not end user's access to semantic model with DataFlows, but It was the problem on my site. I've had global permissions in Power Query desktop set to my account, so that no matter who was logged in, the problem occured. Since I deleted global permissions end user could not get the private data via Power Query desktop.

View solution in original post

2 REPLIES 2
kkozmic
Frequent Visitor

Thanks for the advice, but I fixed the problem by myself. The problem was not end user's access to semantic model with DataFlows, but It was the problem on my site. I've had global permissions in Power Query desktop set to my account, so that no matter who was logged in, the problem occured. Since I deleted global permissions end user could not get the private data via Power Query desktop.

aj1973
Community Champion
Community Champion

Hi @kkozmic 

Ideally Dataflows should be owned by the Workspace and End Users with read only access should consume the reports and dashboards in Power BI App.

So lets say you create a Dataflow in WS_A and then the Semantic Model in a WS_B and for production the Report(Or thin report) in WS_Prod. From WS_Prod create the App and add your audience but don't forget to add access permission on the semantic model in WS_B in order for the user to view data in App.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.