Forum Discussion
RLS: multiple roles per user
I have a big semantic model with RLS set up.
Some users have multiple roles. It used to work very well and used to result in a union of what they are allowed to see based on the roles.
Now for whatever reason a user that has 2 roles, can't see everything he is supposed to see based on 1 of his roles. I can test it by checking a report in service with view as role and view as user. This is very confusing. Please advice!
Did anything change in the way RLS work with the june release?
2 Replies
Hi Olala ,
Multiple roles are not recommended. "When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters."
Here is additional information:
https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance#create-roles
That is what I want them to see... But I figured it can cause strange results for some measures
