Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
prinuce
Helper I
Helper I

Row level Security

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. 

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@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())

View solution in original post

4 REPLIES 4
prinuce
Helper I
Helper I

please help

amitchandak
Super User
Super User

@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())

Thank you sir

Great sir, 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.