Easiest No-Maintenance Row-Level Security!

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):

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

[Craeson]

Took me three days of truoble-shooting until i found your video and got the solution I was looking for. You are a life-saver Christine ❤❤

[luigir]

Perfect timing on my end. Now that our data is somewhat usable we are finally creating reports which need RLS. Thank you :)

[JustinDS]

I think I am your new BIGGEST FAN! Thank you so much for these walk thrus!

[jonellemorgan]

This must be the first video I've seen that has helped me understand RLS. Thank you so much :)

[daryam]

This is THE best video on Power BI RLS! Thank you!

[MrCutlash]

Appreciate this video, this info is hard to find. I read that if you're using dataverse and set directquery in the datasource, the row level security is automatically accounted for. I assume performance won't be so great. just another tidbit of info.

[coreyayers]

Really good video! Thanks for sharing!

[juanperezacuna]

Thank you so much, this video tip help me a lot!

[alvegrande]

Loved the videos but you may want to zoom in when youre writing dax or pointing to sumn because its so small i can barely see it

[bingoo]

Very helpful video.
Just a request can you please share the pbix file used in the video
for better understanding
or just data

[hnaidu.pro]

I'm the 100th person to like the video. Very Informative. Can't be better than this.

[morgannicholsspector]

This is a wonderful resource—thank you!

However, with this solution, it seems users are able to see data of those above them as well—so you have a solution so that users only see data of people in their down line?

[Xwap]

The resolution of your monitor is much higher than your recording resolution, which creates distorted text for viewer.

[tinaflemons]

Great Video, thanks for sharing. How could this approach be extended to the region, district, or branch access view?

[mirrrvelll]

Great and simple!

Question, I guess it is quite advanced, but do you have any link or idea how to achieve the same but taking in account that my data model is made from direct query source, where RLS according to my knowledge and googling, cant be applied. Test as user doesn't function.
Do you have an idea how to do that?

[seyiabayomi]

Thanks for sharing. In a case where an email can access 2 or more sales orders?

[summertime]

Does this allow second level managers to see all the people that align through them (in their downline), not just their direct reports?

[erinfield]

5:38- What if we do the DAX, set up the role and then each user sees nothing?
Edit- figured out that when you go in to view as other user, you have to enter in their e-mail address, not their name.

[gauravchouhan]

How to deal if one person has 2 or more managers ?