web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Department Hierarchy export option

(0) ShareShare
ReportReport
Posted on by 100

Hello,

From Organization Administration page, if i click on Department Hierarchy; there is no option appearing to export this data.

Is there a way to pull the hierarchy structure in one single sheet?

Thanks,
Akanksha Jha

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Akanksha,

     

    There is no simple option to export the Department Hierarchy (or position & organizational hierarchy).

    Wat you could do is export the data via data entities, and import those in visio or Power BI.

    Typically Visio is the easiest solution, but will need some time to get this working:

    pastedimage1590572646237v1.png

  • qianwang Profile Picture
    7,168 on at

    Hi AkankshaJha,

    Yes. Unable to export department hierarchy from UI.

    Therefore it is recommended that you use Microsoft Visio to edit the data entity.

    This is an example of exporting the position hierarchy in ax. You can refer to it.docs.microsoft.com/.../export-a-position-hierarchy-to-microsoft-visio

    1072.png

    Regards,

    QianQW

  • AkankshaJha Profile Picture
    100 on at

    Hi QianQW,

    I have already used Microsoft Visio option for Position Hierarchy; but the issue is related to Department Hierarchy where this option is not available.

    Regards,

    Akanksha Jha

  • qianwang Profile Picture
    7,168 on at

    Hi AkankshaJha,

    Yes, But you can still export the departments. Then import the data to Organization Chart template.

    108.png

    Regards,

    QianQW

  • Suggested answer
    Community Member Profile Picture
    on at

    Just to have all the information. The data entity that holds the department hierarchy (all organizational hierarchies) is the following:

    pastedimage1590645890616v1.png

    Please reach out for additional questions.

  • AkankshaJha Profile Picture
    100 on at

    Hello,

    So it means that the hierarchical (graphical) export of department is not possible; only the export to excel can be done for the complete list of departments.

    Hope my understanding is correct.

    Regards,

    Akanksha Jha

  • Suggested answer
    Community Member Profile Picture
    on at

    Yes,

    You can only export the departments and the department hierarchy into excel.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans