Row Level encryption allow admin to see all

[kezza04]

Hi 

Loving the row level encryption.  Cannot figure out how to provide access to admin to see all of the data

So I have a filter on a group for manager records and another on users records using "[Email] = USERPRINCIPALNAME()"

would like the admin to see all

[amitchandak]

@kezza04 , if user is workspace admin, the RLS do not apply. make the person workspace admin

or have code like

Switch( True(), [email] ="admin@abc.com" , true(),

[Email] = USERPRINCIPALNAME(), true(), false())

[kezza04 · Accepted solution]

Thanks.

I have found the solution I needed here.

Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD

[kezza04]

Thanks.  this is not yet a cloud report so first idea won't work.

I tried the switch statement exactly but that is not working either with no data showing for the admin user.

[kezza04]

The way I need it to work is if admin don't apply filter, else apply filter.  With the code you provided it seems to me the filter will always be applied?