Full RLS

[Balhemkan]

Hi Team, 

I have created one RLS to restrict access for particular users. 

But I Need to create one more RLS for full access. 

Could you please help me how I can create role in power bi to give full access instead of giving admin access in AD group

Ex: Apart from users who are there in Role 1 rest everyone can see complete report without RLS. 

Please help

[v-easonf-msft · Accepted solution]

Hi， @Balhemkan 

Giving admin access in AD group means that these users have edit permission for the dataset, so RLS will not apply to them.
If you don't want to assign admin access, you have to create a role with full access to each data table.

For the code of the related Table filter Dax expression, please refer to the following thread:

Configuring “all” access with dynamic row-level security 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Balhemkan , We usually create a table where the user and access all rows are there

Assume I want to give brand to user and have data like

abc@abc.com brand1

ced@abc.com all

Then we try convert this data like

abc@abc.com brand1

ced@abc.com brand1

ced@abc.com brand2

ced@abc.com brand3

.....

then we can use

email = userprincipalname()

and make sure we join brand to brand dimension