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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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