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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
tbrownParts
Regular Visitor

Measure results disappear when row level security is applied

I inherited a report that calculates commission totals for sales reps.  After updating the calculations within the measures to this year’s goals we went to test the row level security to find the results of the measures don’t appear for the sales group.  The management group can see everything just fine.   The security works fine with each rep only able to see their name, but the results from the measures are not visible in the matrix that’s bult for them.   Also, other measures on the matix work just fine.  Just the ones updates were made to are not working.      

We’ve double checked the security, and nothing is showing to be filtered that shouldn’t be. 

Tried building the same visual on a different page.

Tried to rebuild the measures from scratch all without luck.  

Any suggestions on what could cause this and how to troubleshoot?  

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @tbrownParts 

 

It sounds to me as if you've got an access issue where. the particular users cannot see the measure due to some restriction if there. is no restrictions and the measure works I would suggest testing the row level security roles in power BI desktop.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
tbrownParts
Regular Visitor

The row-level security was our first thought as well.  The problem is fixed.  Turned out a relationship was created between two tables that should not have been.   

GilbertQ
Super User
Super User

Hi @tbrownParts 

 

It sounds to me as if you've got an access issue where. the particular users cannot see the measure due to some restriction if there. is no restrictions and the measure works I would suggest testing the row level security roles in power BI desktop.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors