Row level security

[Anonymous]

I have data as employee and supervisor are directly linked.

I applied the RLS on supervisor which is working fine by showing data of all reportees undee a supervisor.

Requirement is to achieve RLS where supervisor can see all reportees and all the reportees under a reportee.

How can this be achieved? Dynamic Row level security 

[v-robertq-msft]

Hi, @Anonymous 

According to your description, you want to apply RLS on your users who have the hierarchy, I think you can follow these blogs to achieve the dynamic RLS via Hierarchy in Power BI:

https://blog.jameyjohnston.com/row-level-security-in-power-bi-using-parent-child-hierarchies/

http://angryanalyticsblog.azurewebsites.net/index.php/2016/12/27/dynamic-rls-via-hierarchy-in-power-bi/

https://www.sensdat.com/publications/power-bi-row-level-security-pattern/

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

RADACAD have a number of articles on that topic, like this one: Dynamic Row Level Security with Organizational Hierarchy Power BI - RADACAD

[lbendlin]

Needs more details. How did you implement RLS?  Do you have a supervisor role and a reportee role, or is your RLS based on an external reference table that lists permissions per email address?

[Anonymous]

Yes I have created a supervisor role and filter on the username of the supervisor. This table is exactly similar to classic employee and manager table. I have employee if followed by a column which specifies direct reportee.