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.
What do you mean by "Because of our company policy I am limited to adding each user individually"? Adding to what?
If you have access to your AAD security groups via Graph API or AAD Power Automate connector, then you could query AAD for a dynamic list of users you'd then feed to your RLS rule.
I can't create security groups for example and even my access is limited. Luckily for me, I was allowed to use the distribution group, which is managed by our company. But I am still wondering if a dynamical filter is possible without using RLS...