Row level Security

[prinuce]

Dear Power BI Champ, 

i have created organization level hierarchy.

Dear Champ,

I have assign RLS for all user.

Dax is:- 

PATHCONTAINS(RLS[Path],
MAXX(
filter(RLS,
[Employee Email] = userprincipalname()),
RLS[Full NameId]))

@. But my question now i want to assign one person on RLS to see all details in report not only related to him. Please help me on this.

@mapowe @amitchandak @TomMartens @Pragati11 AND Other online user. 

[amitchandak · Accepted solution]

@prinuce , based on what I got so far. else please explain with example

I want to ignore one user and allow him all access , use this inside the manage role

security filter

if(userprincipalname() = "abc.com", true() , [Employee Email] = userprincipalname())

[prinuce]

please help

[amitchandak · Accepted solution]

@prinuce , based on what I got so far. else please explain with example

I want to ignore one user and allow him all access , use this inside the manage role

security filter

if(userprincipalname() = "abc.com", true() , [Employee Email] = userprincipalname())

[prinuce]

Thank you sir

[prinuce · Accepted solution]

Great sir,