cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mopalla
Frequent Visitor

Employee Hierarchy - Row level security

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.

mopalla_0-1609770703904.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

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
Community Champion
Community Champion

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

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.