Forum Discussion
RLS Hierarchy definition
I need to implement the following RLS, with following hierarchy Industry -> Regions - > Account
Senario 1: If a user is defined under Industry, they should have access to all rows of Industry/Regions/Account
Scenario 2 : If a user is defined under Region , they should have access to only the defined region of that Industry and all accounts in that region
Scenario 3 : If a user is defined to have access only to an accounts, they should have access to defined account for that Industry/Region
Industry and Regions can contain multiple value, so filtering needs to be work as per the hierarchy
1 Reply
Hi Anonymous ,
In my opinion, this hierarchical relationship of RLS is essentially that of OR.
[Industry]=USERNAME||[REGION]=USERNAME||ACCOUNT=USERNAMEJust as the sample :
'Table'[Industry ]="A"||'Table'[Regions ]="A"||'Table'[Account]="A"When J view the report:
And if the fact data and rls not in a table ,you could refer the following :
https://community.powerbi.com/t5/Desktop/RLS-row-level-security-and-OR-operator/m-p/2317077#M837656
And you could refer the following article ,it also tells about RLS Hierarchy:
https://community.powerbi.com/t5/Desktop/RLS-Hierarchy-TEXT/m-p/2011273
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
