Forum Discussion
Alternatives for Row Level Security to avoid managing the RLS role list
Hi oemer_erguen
If you want to filter data based on users, you can only do it through RLS. As Anonymous mentioned , you can use usernameprinciple() to make the RLS dynamic . To create a dynamic RLS, you can follow the steps below.
- Filter functions in DAX
- Create Roles in RLS
- User Access Management (UAM)
- UAM with Distribution List
- Dynamic RLS
- Filter Direction and Security Filter Direction
I found a few samples for you, you can refer to .
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
https://medium.com/analytics-vidhya/power-bi-row-level-security-and-dynamic-rls-1ee7faaa703e
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you have the user's email address in your dataset, you could use usernameprinciple() to make the RLS dynamic. What usernameprinciple() function does is it compares the email address user used to access the power bi report and if it matches with the email address present in your dataset it will show only those data that the users have access to.
If you need any guidence to implement this dynamic RLS check out this article. Try this and see if it solvs your problem.