Forum Discussion
RLS row level security - not showing online
Hi Everyone - I have created the following role in my sales table.
[Salesperson (groups)] = "HSRs"
In the online enviornment, if I choose "test role", it works perfectly and only shows the 5 sales people (the HSR team) affiliated with their sales. I can see it using "test role", but the actual users still see ALL of the other sales teams' information.
Even though in the online service I have added their email addresses to this role.
Any suggestions? I have also tested this with a single user, and using the UPN value, and the same thing. I can test the role perfectly fine....but the actual users are still seeing all of the information...not just their own information which is what they should see.
What would cause the "test role" enviornment to work, but not actually show correctly to the other users?
That's correct, it's just them being members that is causing RLS to be ignored.
13 Replies
- jdbuchanan71
Super User
Hello Anonymous
Are the users in question members of the workspace? If so, RLS doesn't restrict their data.
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
If this is the case, rather than makeing them members of the workspace you should just share the report with them.
- jdbuchanan71
Then RLS won't be applied.