Forum Discussion
RashmitaR
Helper IV
9 years agoIncorrect 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
Community Support
9 years agoHi 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
- ldorn767 years ago
Microsoft Employee
did you ever find a solution to this?