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

Community site session details

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

Connect to the MR database and export the reporting tree definitions to Power BI

(0) ShareShare
ReportReport
Posted on by 469

Hi,

We have a requirement to export the MR reporting tree definitions to Power BI. 

We are using D365 F&O 10.0.29.

Is there a way to connect to the MR database through data management or any other tool?

Can we export the MR reporting tree definitions to excel or csv?

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at
    RE: Connect to the MR database and export the reporting tree definitions to Power BI

    Hi,

    Please see if this helps :

    community.dynamics.com/.../exporting-and-importing-financial-report-configuration-from-management-reporter-in-d365-finance-and-operations

  • Suggested answer
    Charlotte X Profile Picture
    on at
    RE: Connect to the MR database and export the reporting tree definitions to Power BI

    Hi Hossam,

    You can refer to the following thread and blog:

    Export Security Groups and Tree Definition from MR - Microsoft Dynamics GP Forum Community Forum

    Export Reports to Excel using Management Reporter in D365 for Operation. - Microsoft Dynamics 365 Blog

  • Hossam EL Hassan Profile Picture
    469 on at
    RE: Connect to the MR database and export the reporting tree definitions to Power BI

    Thanks for the information.

    I am looking at exporting the tree definitions, as we have multiple trees and the hierarchy changes from time to time. 

    So we need to be able to export the data in the tree definitions to excel or csv in order to be able to transfer it to Power BI.

    pastedimage1672434354488v1.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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,100

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 633 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans