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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Solution Authors