Employee Hierarchy - Row level security

[mopalla]

Hi All,

We have a table that consists of employee details in Level based Hierarchy:

I implemented Row level security, so if user logs in he has to view his reportee's and there respective measure and able to drill through further his reportee reportee's.

Can you please help.

[v-stephen-msft]

Hi @mopalla ,

The principles and formulas are in this post, please kindly refer to:

Dynamic Row level security

Best Regards,

Stephen Tao

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

[aj1973]

Hi @mopalla 

My understanding is that you don't know how to set up the RLS in Power BI desktop!

If so refer to this 

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

[amitchandak · Accepted solution]

@mopalla , Issue you are facing is not clear. Can you explain it?

Refer if these can help

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies