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.
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
Solved! Go to Solution.
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
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
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 |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |