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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
HemanthV
Helper II
Helper II

Giving one person RLS to another person

Hello Guys,

 

I have created organizational hierarchal RLS and it is working as expected, but now i need to make a person as a specific manager, so the person can see that manager data and his hierarchal people data.

 

For Example:

E1, E2 and E3 employees reports to Manager1. When Manager1 opens the report he can see his data and E1,E2,E3 data right, but now what i am trying to achieve is, I need to make E4 as Manager1 so that E4 can see Manager1 data and as well as E1,E2,E3 data.

 

Please help on this!

Thanks in advance!

1 ACCEPTED SOLUTION
2 REPLIES 2
JeaneTan
New Member

Hi,

How about if manager A delegate job to B to monitor team's spend. how can I set the RLS?
for example: line manager A can view L1-L7, line manager A want B to view all expenses exactly same as line manager A. 

currently the RLS setting was:

[Level 1]= UPPER(USERPRINCIPALNAME())
|| [Level 2]= UPPER(USERPRINCIPALNAME())
|| [Level 3]= UPPER(USERPRINCIPALNAME())
|| [Level 4]= UPPER(USERPRINCIPALNAME())
|| [Level 5]= UPPER(USERPRINCIPALNAME())
|| [Level 6]= UPPER(USERPRINCIPALNAME())
|| [Level 7]= UPPER(USERPRINCIPALNAME())
|| [Level 8]= UPPER(USERPRINCIPALNAME())
|| [Level 9]= UPPER(USERPRINCIPALNAME())
|| [Level 10]= UPPER(USERPRINCIPALNAME())
|| [Level 11]= UPPER(USERPRINCIPALNAME())
|| [Level 12]= UPPER(USERPRINCIPALNAME())

 

so, B only can view himself and his team only ($100) --> Level 1 - level 3 (expenses of team / teams reporting to them)
how can B can view exactly ($1,000) like line manager A --> level 7 (which spend cover level 1-level 7) under A's organisation? 

thanks.
Regards,

Jeane

amitchandak
Super User
Super User

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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