Row level security

[vjnvinod]

Dear Experts

I have created a role

EMAIL adress=UserprincipalNAME()

and it works fine, as I am maintaining an Excel file which has list of country and Email id

the problem is that I need to give access to few email id who can see the entire dashboard

how can I configure the Row-level security?

[blopez11]

Just create another role, say "Full Access" and for the DAX expression, use 1 or TRUE()

Then assign those few users to the "Full Access" role

This will work as long as they are not part of the other role

[vjnvinod]

@blopez11 

what is use 1? or true()?

Can you write that code?

[Anonymous]

Hi @vjnvinod ,

Here are two ways to achieve your goal.

1. Create a Manager Role without any restriction.

User Role is the same like yours with code like EMAIL adress=UserprincipalNAME().

You don't need to add any code in Manager role. You need to add users in roles in Power BI Service. People in this role can see everything in this report. 

2. You can give these users who you want them see everything edit permission in workspace.

Classic workspace: Add these users as admin or member with edit permission.

New workspace: Add these users as admin , member or contribuer.

There won't be any restriction to these end users by rls. Other words, RLS won't work on these users.

Here is the offical blogs: Using RLS with workspaces in Power BI

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[blopez11 · Accepted solution]

[amitchandak]

@vjnvinod , based on what I got. You need to give all countries along with email id.

example 

Country email

A1  a@abc.com

a2 a@abc.com 

and so on