Configure Row Level Security with OR condition on 4 Dimensions ( the same)

[Cobra77]

Hi

How implement with best practize the RLS with Or condition ?

Actually the secu is on 04 - Principal , its ok :

RLS vt_secu_users :  [upn] = USERPRINCIPALNAME()

Now,  we want a OR condition on  

-> 04 - Principal

-> 05 - Applicant

-> 02 - Beneficiary

-> 03 - Guarantor

these are the same 4 tables

Thanks for your helps.

Best regards.

[amitchandak]

@Cobra77 , RLS condition should return true or false, I did not get the logic, what you want with those 4 columns, Can you explain that.

Just treat the RLS statement like if the condition at line level

[Cobra77]

hi @amitchandak 

if the user user1@group.com  has rights to account code 10250 for example.
Currently only dimension '04 - Principal 'was filtered.

We want that with this code the RLS filters dimensions:

'04 - Principal'[Code] =10250 or 05 - Applicant[Code] =10250 or 02 - Beneficiary[Code] =10250 or 03 - Guarantor[Code] =10250

[v-yingjl · Accepted solution]

Hi @Cobra77 ,

Please consider the 'Apply security filter in both directions ' in the relationships.

By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. 

Refer:

1. Row-level security (RLS) with Power BI 
2. How does Row Level Security works when there is a BI-Directional Filter in Power BI/Tabular Model? 
3. What is “Apply security filter in both directions” (normal vs security filter)? 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.