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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors