Dynamic Row-Level Security for Power BI

Описание: If you are looking to automate your row-level security (RLS) to make it dynamic 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!

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 Auto...  

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