Department hierarchy in Dynamics 365 F&O and HR


It is very difficult for users to export the department hierarchy to excel and there is no option.

In this topic, We can see how to view Department hierarchy In Power BI by using the odata entities.

The department hierarchy in Dynamics 365 F&O and HR depends on below data

  1. Organization hierarchy V2 – published
  2. Organization hierarchy purposes
  3. Organization hierarchy type
  4. Operating Unit

Step 1: Before creating a Power BI report, We need a Power BI desktop installed in our system

Reference link to download : https://powerbi.microsoft.com/en-us/downloads/

Step 2 : Login with your account

Step 3 : Home > Get Data > Select Odata feed

Provide the URL for your environment.

For example https://aos-rts-sf-xxx-prod-northeurope.hr.talent.dynamics.com/namespaces/xxxx/data

It will show all the odata entities and select the entities mentioned above.

Step 4 : We have to use merge queries function between OrganizationHierarchyPublishedV2 and OperatingUnit entity based on Party Number

Step 5: You can download the Organization chart by MAQ software from Get visuals

Once you have visual available then based on queries merge in Step 4, We can assign values in visuals.

Here is my query and Visuals settings

Here is the output

If you select any node then It will display corresponding values at bottom.

Step 5 : Organization hierarchies

Use organizationHierarchyPurpose entity to see the data.

Step 6 : Use OperatingUnit entity to see the overview of operating unit and hierarchy.

Thank you for reading my post and If you have any questions then please let me know.

Next time, I will come up with Position hierarchy.

One thought on “Department hierarchy in Dynamics 365 F&O and HR

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: