Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Connect to the MR data...
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 Hossam EL Hassan 467

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?

Categories:
Management Reporter
  • Hossam EL Hassan Profile Picture
    Hossam EL Hassan 467 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

  • Suggested answer
    Charlotte X Profile Picture
    Charlotte X 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

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 14,918 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

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

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

#1
Jahanvi Profile Picture

Jahanvi 34

#2
PJ JohnPaul Profile Picture

PJ JohnPaul 5

#3
SudhanshuMSID Profile Picture

SudhanshuMSID 1

Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans