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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Dayna
Helper V
Helper V

Lock down access to 'Transform Data' in PowerBI Desktop

Hello All,

 

I'm sharing access to a PowerBI desktop file but there's sensitive data within the report, I'm manipulating this in the Power Query editor, but aware that to see the information I've masked, they simply need to go into the editor and see a previous step.

 

Is there a way to allow access to the desktop file, but lock down access so they cannot get to the query editor?

 

Many thanks,

Dayna

1 ACCEPTED SOLUTION
jolind1996
Resolver II
Resolver II

Unfortunately, it is not possible to lock down access to the query editor in a Power BI desktop file. Anyone with access to the file can open the query editor and view the data transformations and manipulations applied in the Power Query editor.

One way to prevent users from accessing sensitive data is to remove the sensitive data from the Power BI desktop file before sharing it. You can do this by filtering out the sensitive data in the Power Query editor, or by removing the columns containing the sensitive data. Another option is to publish the report to the Power BI service, where you can set up Row-Level Security (RLS) to restrict data access at the row level.

Best regards,

Johannes

View solution in original post

1 REPLY 1
jolind1996
Resolver II
Resolver II

Unfortunately, it is not possible to lock down access to the query editor in a Power BI desktop file. Anyone with access to the file can open the query editor and view the data transformations and manipulations applied in the Power Query editor.

One way to prevent users from accessing sensitive data is to remove the sensitive data from the Power BI desktop file before sharing it. You can do this by filtering out the sensitive data in the Power Query editor, or by removing the columns containing the sensitive data. Another option is to publish the report to the Power BI service, where you can set up Row-Level Security (RLS) to restrict data access at the row level.

Best regards,

Johannes

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors