Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
HI Everyone,
Want to know how we can provide security to business users to a report that contains highly Confidential & Sensitive Data.
Only Business users should have access to the report. Everyone else should not access/see any data of the report.
Please Suggest.
Thanks,
Sreekanth
As far as I'm aware, as long as you administer access to the workspace the report is in and make sure the application admins don't have access to that specific 'highly confidential' workspace then the RLS should govern acess to the model/report and you can still set this on an individual user basis
Hi @Sreekanth_B ,
Thank you for reaching out to the Microsoft Community Forum.
Hi @Col_Mar , Thank you for posting Response in community.
HI @Sreekanth_B , As suggested by @Col_Mar , please follow the steps. and follow the Microsoft official document, regarding RLS with Power BI.
If @Col_Mar response has resolved your query, please mark it as the "Accepted Solution" to assist others.
Thank you
You would need to add RLS to the data model on Power BI Desktop (if you have a table of users or something equivalent) and then also assigned users to this role in the Power BI Service. Think of it as two steps, but you can also test the security you create in Power BI Desktop before you publish and assign them in the Power BI Service.
See below:
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Thanks for Reply, To be More Specifc to my question, Even application ADMINS should not able to see the confidential Data. How can we achive this.
User | Count |
---|---|
43 | |
32 | |
30 | |
27 | |
25 |
User | Count |
---|---|
55 | |
54 | |
35 | |
33 | |
28 |