web
You’re offline. This is a read only version of the page.
close
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, ... / Management Reporter Fi...
Finance | Project Operations, Human Resources, ...
Answered

Management Reporter Financial reports not running in D365 F&O

(0) ShareShare
ReportReport
Posted on by Rhushikesh R 758

Hi Everyone,

Need urgent help on below issue.

I recently upgraded my AX environment from Ax2012R3 to D365 F&O.

I have upgraded the database successfully. However, while running Management Reporter reports I am getting below error.

"This report view contains no data."

Please suggest some solution on same.

6204.MR.png

I have the same question (0)
  • Verified answer
    Ramit Paul Profile Picture
    Ramit Paul 22,797 Most Valuable Professional on at

    Check this we have solved before the similar issue.

    community.dynamics.com/.../financial-reports-not-working-in-dynamics-365-finance-and-operations-after-upgrade-from-ax2012

  • Verified answer
    SouravDam Profile Picture
    SouravDam 11,730 on at

    Looks like no transactions are available in your environment to show in MR report. That could be the reason of showing this on screen info.

    Please check the following.

    -- Financial reporting setup.

    Make sure that you selected the combination in the same way as it is configured in both "Account structure" and "Financial dimension combination for integrating applications" forms.

    3833.JPG

    -- Have a look in the row definition of the MR report and see which main accounts / account categories have been mapped.

    -- Post few transactions based on those accounts.

    -- Generate this report for the same time frame where you posted the transactions.

    If still no result display in the report; then click on Tools > Refresh cached financial data and generate the report again.

    If no luck yet, then go back to Tools > Reset data mart and see if this solves your case.

    Once the status in reset data mart for all processes becomes "Ran to completion", then generate the report again.

    Regards,
    Sourav

  • Rhushikesh R Profile Picture
    Rhushikesh R 758 on at

    Hi Sourav, I tried resetting Data Mart and now getting below error. Please help me. Am I lost any configuration which needs to be done?

    MR-Data-mart.png

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,797 Most Valuable Professional on at

    Hi,

    Close designer and open once again in incognito with correct credential.

  • Verified answer
    SouravDam Profile Picture
    SouravDam 11,730 on at

    Not sure if this could be any upgrade related issue!

    Better check with the developer and get this fixed.

    Also can check below links if it helps.

    https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/307959/reset-financial-reporting-data-mart-dynamics-365-fo-on-premises

    https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/reset-financial-reporting-datamart-after-restore

    If developer cannot fix it, then log a support case to Microsoft for clarification.

    Keep us updated once this is sorted out.

    Regards,
    Sourav

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,710 Moderator on at

    Hi Rushikesh ,

    On which environment you are trying to run  financial reports ? Did you try to reset data mart ? You can give it a try with the help of below links and see if it helps.

    denistrunin.com/.../

  • Rhushikesh R Profile Picture
    Rhushikesh R 758 on at

    Hi Sukrut,

    I am trying to run the reports on Azure Dev VM , PU35.

    When I tried resetting Data mart , I started facing the new issue of connection with Database failed.

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,710 Moderator on at

    If its a dev VM , you must have SQL access , if not add yourself with someones help and get access to financialReportingDb and then try to run report. If still reports are not working try resetting data mart.

  • Rhushikesh R Profile Picture
    Rhushikesh R 758 on at

    Hi Sukrut, may I know how can I run the report through SQL? And also I would like to clarify that, I already attempted Reset Data Mart once. But when I open management reporter now, I am getting below pop up. Would you please suggest solution on same? Does the pop up meant Reset Data Mart hasn't been completed successfully? 

    7612.MR-Data-mart.png

    Also would you please confirm me, under which category I should log the ticket to Microsoft to resolve this issue?

    LCS-Cat.png

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,797 Most Valuable Professional on at

    You can raise under Finance applications, from there you shall get management reporter option

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans