Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
Solved! Go to Solution.
@HemanthV , refer if this blog can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
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
@HemanthV , refer if this blog can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
206 | |
90 | |
61 | |
59 | |
57 |