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.
I would like to assign a heirarchy of viewer permissions per the following example:
Each Manager can only view the performance of their direct reports
Each Manager cannot view the data of other Managers and their direct reports
The Senior Manager can view all of their reporting Managers and direct reports
I have a filter for Senior Manager by name and filter for Manager by name beneath it
My goal is when the Manager/Senior Manager views the report they do not have the option to view other Managers data.
How can I achieve this?
Much appreciated,
Dan
Solved! Go to Solution.
hi, @dan_johnson
USERNAME() function returns the username from the credentials given to the system at connection time.
and for your case, you could use USERNAME() function with Row-level security (RLS).
here is some reference:
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
http://radacad.com/row-level-security-configuration-in-power-bi-desktop
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
Lin
hi, @dan_johnson
USERNAME() function returns the username from the credentials given to the system at connection time.
and for your case, you could use USERNAME() function with Row-level security (RLS).
here is some reference:
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
http://radacad.com/row-level-security-configuration-in-power-bi-desktop
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
Lin
Thank you Lin,
This is very helpful!
Dan
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |