Dynamic Row-Level Security in Power BI

If you are looking to automate your row-level security (RLS) or apply it to your entire organization, using the management reporting chain is a great option. This will let your leadership see data for anyone under them in the reporting hierarchy without having to add individual users to different roles! We use PATH() and PATHCONTAINS() here to achieve this result.

If you do not have a table of user data, which this technique requires, you can get it with Power Automate using this video (filter the resulting data on "UPN does not contain #EXT" to remove external users):
Get ALL User Profile Data using Power...

0:00 Intro/demo
2:53 Relate staff table to data
3:28 Create a PATH() calculated column
4:30 Create the RLS rule
5:30 Test the rule
5:55 Add to role in web service
7:30 Test as role in web service

• #science_technology
• #tutorial