RLS: multiple roles per user

[Olala]

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?

[Olala]

That is what I want them to see... But I figured it can cause strange results for some measures

[djurecicK2]

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