Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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
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
thanks
@v-jayw-msft ...this worked. Is there any limitation on how many members can be added per role?
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
@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.
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
User | Count |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |