Forum Discussion

Cobra77's avatar
Cobra77
Post Patron
5 years ago
Solved

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

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 O...
Need Help
Show and Tell
Cobra77's avatar
Cobra77
Post Patron
5 years ago

hi amitchandak 

 

if the user [email protected]  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's avatar
v-yingjl
Community Support
5 years ago

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.