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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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

Top Solution Authors