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.
You could try using the username/userprincipalname DAX function in combination with a list of user emails being present in your dataset and see if that works. I never tried it in the absence of RLS rules I so I'm not sure it will work though.