Forum Discussion
RLS - can't load data when user has been assigned multiple roles
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?
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.
2 Replies
- nandukrishnavs
Community Champion
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)
V-lianl-msftCommunity Support
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.
