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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
007Raj
Frequent Visitor

Row Level Security not working for grand total of the matrix

Hello everyone,
@amitchandak 
@olgad 

@Sahir_Maharaj 

@Greg_Deckler PowerBI Access Relationship.png
I tried searching for a similar topic but could not find anything. 

 

Its quite weird issue I am facing with Row Level Security.

The access tables are connected via a two way filter with many to many relationship with apply security filter in both direction ticked.

 

Rest everything works fine in terms of rls, the issue is in the matrix total, it shows all the data instead of rls filtered entities (e.g. company)

 

Request your quick assistance in troubleshooting it.

 

Let me know if any further info is required from my end

1 ACCEPTED SOLUTION
007Raj
Frequent Visitor

Thie issue stands resolved. The issue was in apply security check which I checked for access table but the issue was in another dim table since its a complex structure .Apply security.png

View solution in original post

2 REPLIES 2
007Raj
Frequent Visitor

Thie issue stands resolved. The issue was in apply security check which I checked for access table but the issue was in another dim table since its a complex structure .Apply security.png

excellent observation, big help.

Helpful resources

Announcements
Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.