Forum Discussion
RashmitaR
9 years agoHelper IV
Incorrect row total when row level security is applied
Hi, I have applied row level security in my report and when one of my user is having a look at it he is able to see the unfiltered row total . Can someone plese let me know how to correct...
v-qiuyu-msft
9 years agoCommunity Support
Hi RashmitaR,
Based on my test in my environment, I'm not able to reproduce the issue like yours. I create a matrix visual and place a field value in Value Property, set the role based on UserName(). See:
In your scenario, please check which value did you place in Value property of matrix visual, a field or measure? Please try to use a filed like us to see if the row total is correct after using RLS. Also please test a role as the user's email address as above use Test As Role. For more information, please refer to this article: Row-level security (RLS) with Power BI.
Best Regards,
Qiuyun Yu
ldorn76
7 years agoMicrosoft Employee
did you ever find a solution to this?