Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Cobra77
Post Patron
Post Patron

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()

Cobra77_0-1623144474330.png

 

 

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.

 

1 ACCEPTED SOLUTION

Hi @Cobra77 ,

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

rls-apply-security-filter.png

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.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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

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

Hi @Cobra77 ,

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

rls-apply-security-filter.png

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.