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,
Does PowerBI have the ability to identify a user that can be passed through a dataset to show only relevant data and hide data we do not want them to see dynamically?
For example, lets say we have a table of all Managers and would like to generate a list of all direct reports to the Manager only. The Managers would be able to see their Staff only. The next Manager who clicks on the page from their machine would see their own staff only.
Is there a way to do this with PowerBI? If yes, what method is best practice? And can AD values be passed and used to help make decisions?
Solved! Go to Solution.
You want to look up Row Level Security
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Hi bcap, yeah the same solution will still work 🙂
Thank you, this article helps! Now, what if I want to create another level of security for the same report. for example, if I would like the Director to see all Managers that belong to him/her? Is this still RLS? Or do I need to consider another approach?
Hi bcap, yeah the same solution will still work 🙂
You want to look up Row Level Security
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |