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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
akhaliq7
Post Prodigy
Post Prodigy

Protect dataset from a user (security)

I have built a report with a dataset I would like to protect from another user. I would like to give access to the pbi file and allow them to export the data to excel from a table visual in power bi desktop, the only limitation I want is that the person cannot access the complete data in power query and export the complete dateset in power query to excel. What restrictions can I place to achieve this.

1 ACCEPTED SOLUTION
nickyvv
Most Valuable Professional
Most Valuable Professional

Hi @akhaliq7 ,

 

unfortunately this is not possible at the PBIX-file level. Once you give the PBIX-file, the user has access to the whole file and all the data inside. Unless you're using Direct Query to get the data, then the user also needs access to the source.

But if you want to give access to (a portion of) a report, I'd suggest publishing it to the service and going from there. For example with row-level security or putting a report in an app and sharing that with the user.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


View solution in original post

1 REPLY 1
nickyvv
Most Valuable Professional
Most Valuable Professional

Hi @akhaliq7 ,

 

unfortunately this is not possible at the PBIX-file level. Once you give the PBIX-file, the user has access to the whole file and all the data inside. Unless you're using Direct Query to get the data, then the user also needs access to the source.

But if you want to give access to (a portion of) a report, I'd suggest publishing it to the service and going from there. For example with row-level security or putting a report in an app and sharing that with the user.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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