Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anmolgan
Post Prodigy
Post Prodigy

What are the best visuals to represent company employee and managers Hirearchy?

I used this link to build a hirearchy of a company: 

 
Now the problem is I am looking for the best visualization so that I can represent this hirearchies correctly may be a nested slicer or tree chart will work but i am not getting anything to work here.
 
Also how can I test out this in the PowerBI Desktop, I dont have the correct userid to lookup to I only have the complete email ID of the employees, how can I write the role so that user should see there own data according to the hirearhcy whenever they login to the PowerBI Service?
1 ACCEPTED SOLUTION

@Anmolgan ,

 

You need to create an additional UPN table and create a RLS role in power bi desktop and using the PATH() function. In power bi service, you need to add the user email to that role.

 

Please refer to: https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

 

Community Support Team _ Jimmy Tao

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

View solution in original post

4 REPLIES 4
sarveshpandey23
Frequent Visitor

I'm facing the same issue. 

v-yuta-msft
Community Support
Community Support

@Anmolgan ,

 

You need to build hierarchy RLS using PATH() function, you may refer to: https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi.

 

You may use hierarchy slicer to view the organization member. https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview

 

Community Support Team _ Jimmy Tao

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

@v-yuta-msft  Thanks for the response, how can validate this in powerbi desktop, I have built out the path function, but not sure how to validate this in powerbi service and powerbi desktop

@Anmolgan ,

 

You need to create an additional UPN table and create a RLS role in power bi desktop and using the PATH() function. In power bi service, you need to add the user email to that role.

 

Please refer to: https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

 

Community Support Team _ Jimmy Tao

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.