Multi level RLS suggestions

[Anonymous]

Hi,

Sorry if this is posted, but I can't seem to find exactly what I'm looking for. 

I have a employee table, company table and a department table. 

Som employees need to see the whole of their company, while others can only see their department in their company. 

Can anyone suggest to me articles that solves this exact issue?

Thank you so much!

[v-yangliu-msft]

Hi  @Anonymous ,

Here are related operations and videos about dynamic RLS, I hope it will help you:

https://www.acuitytraining.co.uk/news-tips/dynamic-row-level-security-in-power-bi/

https://www.youtube.com/watch?v=u-vTMUZwilE

https://www.biconnector.com/blog/power-bi-steps-to-setup-rls-row-level-security-static-and-dynamic/Best

Regards,

Liu Yang

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

[amitchandak · Accepted solution]

@Anonymous , In such a case we create an employee email(login), department. those employees need to see all depart will be assigned and have an entry for each department for those employees and then you join that with department dimension and create a role on rls table

email = userprincipalname()

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk