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 everyone,
Here is an example of data i am working with :
Fact table
Managers table
And here is the role that i've created for test :
I am working on a business need who requires that a manager could see the global amount of his collegues but not the details.
Initial report looks like that :
Below the result when i apply my role :
But what i really need is this :
A picture is worth a thousand words : the manager (M1) have to access only the data of his station (G11) or the global amounts of his hierarchy.
Do you have any idea how could i achieve this ? I would greatly appreciate any insights or help.
Kind regards,
I don't think you can use static RLS for that. Consider using dynamic RLS.
Any idea how to do this with dynamic RLS ?
It's as simple as maintaining a permissions mapping table that you control via USERPRINCIPALNAME.
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |