Forum Discussion
Implementing Dynamic RLS based on logged in user email
Hello all,
I need help while implementing DYNAMIC RLS. I want to filter data for user logged in and tried to implement it.
When I click on "View as role" and select role name (in my case role name is "Dynamic RLS") - I am able to see exact data.
But the issue comesup when I enter an email in "View as Roles -> Other User". It is not filtering the dataset and all data is displayed.
Image is attached with details.
Can someone please advise.
Hi Anonymous
We configure RLS in Desktop and manage RLS in Service .After you configuring RLS and publishing the report to Service , you need grant roles to users in dataset => open menu=>Security .
Add users account in the role and then test as a role .
For specific operations, you can refer to the link beolw .
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
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.
4 Replies
Apart from adding "[email protected]" in the box for Other User, you also need to check "Dynamic RLS" for it to apply the role to the Other User. Have you tried that?
Hi Anonymous
We configure RLS in Desktop and manage RLS in Service .After you configuring RLS and publishing the report to Service , you need grant roles to users in dataset => open menu=>Security .
Add users account in the role and then test as a role .
For specific operations, you can refer to the link beolw .
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
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.
