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. A...
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
Community Champion
Community ChampionAnonymous
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)