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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.