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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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