Hierarchy row-level security

[Balaji18077]

I have 5 tables. The first table is Access Rights contained below data.

Next, the second table is the supply chain contained below data.

The third table is the Region contained below data.

The fourth table is the Plant contained below data.

The first table is the GEO INFO contained below data.

I need to Implement a Hierarchical row-level security based on the above data.

In the first table, I am a user of Thomas.Lokay@mogroup.com. For this user Plant is ALL, supply chain is MSC, and Region SAM. I should able to see the data of all Plants data filtered with Region and Supply chain. For example, If Plant is ALL and Supply Chain is ALL and Region is SAM. Then I should be able to see all the Plants and Supply Chain data filtered with Region. If all Plant, Supply Chain, and Region are ALL. Then I should be able to see all the data. It should be dynamic.

I need advice on how to implement Row-Level Security (RLS) based on the above requirement.

Thank you.

[Anonymous · Accepted solution]

Hi @Balaji18077 ,

If you want to learn about a scenario that everyone will see their own data, but the manager will see everything. You can refer to the below blog, it's about creating a scenario with manager level access, and employee level access.

Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD

Best Regards,

Stephen Tao

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