Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Department Hierarchy export option

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Department Hierarchy export option

    Yes,

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

  • AkankshaJha Profile Picture
    AkankshaJha 100 on at
    RE: Department Hierarchy export option

    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
    Community Member Microsoft Employee on at
    RE: Department Hierarchy export option

    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.

  • qianwang Profile Picture
    qianwang 7,151 on at
    RE: Department Hierarchy export option

    Hi AkankshaJha,

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

    108.png

    Regards,

    QianQW

  • AkankshaJha Profile Picture
    AkankshaJha 100 on at
    RE: Department Hierarchy export option

    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
    qianwang 7,151 on at
    RE: Department Hierarchy export option

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Department Hierarchy export option

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans