Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hello,
URGENT!!!!
Need to apply Hierarchical RLS for employees with multiple managers. But i am getting following error.
EmpIDManagerIDPath
| E2004 | E188 | #ERROR |
| E2005 | E188 | #ERROR |
| E2005 | E182 | #ERROR |
| E188 | E70 | #ERROR |
| E182 | E161 | #ERROR |
| E70 | E146 | #ERROR |
| E161 | E146 | #ERROR |
Here is the dummy data.
Can anyone help me with a solution for this scenario.
Thanks in advance!
Hi @Anonymous ,
EmpID.E2005 has two and corresponds to different ManagerIDs:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hello,
Thanks for response.
I need a solution for multiple managers. Actually one employee have 2 managers. Is there any way to solve this ?
@Anonymous , It is giving a duplicate value error in empid column. Also a mgr d need to be in emp if too
Check for any duplicate in emp id column
Hello,
Thanks for response.
I need a solution for multiple managers. Actually one employee have 2 managers. Is there any way to solve this ?
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 21 | |
| 17 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 50 | |
| 37 | |
| 29 | |
| 24 |