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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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