Forum Discussion

mandeepdhillon's avatar
mandeepdhillon
New Member
5 years ago

One user in multiple roles causing row level security to stop applying

I will try my best to describe the issue I am having. I have several roles against several tables. When only one user is assigned to a single role, everything works fine, but soon as one user is assi...
Need Help
v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, mandeepdhillon 

According to your description and sample picture, I think you want to assign Multiple Roles to one user using RLS in Power BI, I think you can follow these cases and documents to create the correct tables and Organizational Hierarchy to achieve this:

https://community.powerbi.com/t5/Desktop/Row-level-security-multiple-roles/m-p/866260

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

https://community.powerbi.com/t5/Desktop/power-bi-rls-implementation/m-p/358535#M161644

https://community.powerbi.com/t5/Desktop/Row-level-security-with-multiple-roles/m-p/304964

 

Best Regards,

Community Support Team _Robert Qin

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