Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

RLS on multiple condition

I have a access list, One column name is Job Function (has HR, IT, Fin, SCM etc) and Manager of People (Yes, No). I need to implement RLS so that all HR can see the data but Manager of People has (Ye...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

    Based on your picture and description, you want to set the RLS based on the levels, you can use path() function in user table to  completely show the relationship between superiors and subordinates , you can refer to the following case, it is  similar and I offered some solutions, hope it helps

    Solved: when user log in the metrix should show the Hierar... - Microsoft Fabric Community

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

Based on your picture and description, you want to set the RLS based on the levels, you can use path() function in user table to  completely show the relationship between superiors and subordinates , you can refer to the following case, it is  similar and I offered some solutions, hope it helps

Solved: when user log in the metrix should show the Hierar... - Microsoft Fabric Community

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.