How to configure row level security

[Anonymous]

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!

[v-jayw-msft · Accepted 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

[Anonymous]

thanks

@v-jayw-msft ...this worked. Is there any limitation on how many members can be added per role?

[v-jayw-msft]

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

[Greg_Deckler]

@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.

[Pragati11]

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