RLS - can't load data when user has been assigned multiple roles

[Anonymous]

Hi all

My dataset relates to a project with multiple teams. As users should only view their own team's data, I have set up RLS using USERPRINCIPALNAME. This was working fine until recently.

As some staff members work on more than one team, they were assigned multiple roles. I have a USERS table with the team names and organisational IDs, with a relationship connecting to my TEAMS table. 

Users with only 1 team can access the reports fine with no issues. Now I am getting reports of errors but only by users who work on more than 1 team. The error they get is per the screenshot:

Can anyone advise as how to resolve?

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, you could need dynamic RLS with a hierarchy.

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nandukrishnavs]

@Anonymous 

Can you provide more information?

How many roles you have?

What is the filter condition?

Can you share a snapshot of the data model view (relationship)