Forum Discussion
How to configure row level security
Hi,
I need to restrict data access in my power bi report. Following are the categories that I want to define:
1. Category 1 - Users should be able to access all data (no restrictions to be applied)
1.1 the user email id is present in my back end dataset
1.2 the user email id is not present in my back end dataset
for both 1.1 and 1.2 the users should be able to view all data and access the dashboard
2.Category 2- Users should be able to access data relevant to them
For category 2 I have configures RLS using userprincipalname() dax and it is working fine.
How do I configure for category 1.
Thanks!
- Anonymous6 years ago
Hi Anonymous ,
You can create a new role "all" set all table filter dax expression as true. Then set these users as "all" role.
Best Regards,
Jay
5 Replies
- AnonymousNot applicable
Hi Anonymous ,
You can create a new role "all" set all table filter dax expression as true. Then set these users as "all" role.
Best Regards,
Jay
- AnonymousNot applicable
thanks
Anonymous ...this worked. Is there any limitation on how many members can be added per role?
- AnonymousNot applicable
Hi Anonymous ,
As far as i know, there's no such limitation. You can check the offical document about RLS.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#limitations
Best Regards,
Jay
- Pragati11
Super User
Hi Anonymous ,
Kindly refer the following article on how RLS can be used in Power BI:
https://radacad.com/row-level-security-configuration-in-power-bi-desktop
Thanks,
Pragati
- Greg_Deckler
Community Champion
Anonymous - I forget exactly if it is necessary but one way I have done this is to create a column in a table that is simply:
Column = 1
Then you set your DAX Role RLS rule to be Column = 1. Presto, people in that role can see everything.