Row Level Security and Permissions

I have a simple report that I want to set RLS based on each Manager’s location. I also wish senior managers to be able to see the entire data. If I set up each Manager with his/her appropriate role, will Senior Managers see the entire report, or do I have to set up a senior role to assign to Senior Managers?

Hi @jmolina,

You can rely on the Active directory to do so. We have many great discussion on the forum. Please have a look to below link.

Also a video from Darren which shows how to do it using DAX Studio.

And another one which i used recently.

Hi @jmolina, did the response provided by @MK3010 help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!