Small and medium business | Business Central, N...

Power BI Sales App, Month-To-Date report shows Fiscal Year although set to Standard Calendar in BC.

(6) Share

Report

Posted on by JP-10011441-0

Hello everyone,

We have recently started to use the Microsoft Power BI Reporting Apps for Business Central. In the Connector Set Up within Business Central (Version 25.3) we are prompted to set a "Calendar Type", we chose to use Standard Calendar. When viewing the Sales App Month-To-Date report, however, the information is provided according to Fiscal Year.

Has anyone else set their calendar to Standard in Business Central and correctly views the Month-To-Date information in the Sales app (also in Standard Calendar)? Are we able to change the reporting of said data to display using the Standard Calendar instead of Fiscal Year or is the Fiscal Year view hard coded into the Sales App by Microsoft? (Please See Below)

Thank you in advance,
Juana

Power BI Dynamics 365 Business Central Sales Reports > Month-To-Date Report

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 81,857 Super User 2025 Season 1 on at

Like (1)

Report

Power BI Sales App, Month-To-Date report shows Fiscal Year although set to Standard Calendar in BC.

Currently, the Power BI app is not customizable, so I don’t think it can be done.

You can submit feedback to Microsoft

Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas

PS:

aka.ms/BCYammer: Dynamics 365 Business Central Partner Community (Formerly: Development)
More details: About Business Central partner community on Viva Engage (formerly Yammer)

Thanks

ZHU
Suggested answer

Khushbu Rajvi. 15,085 Super User 2025 Season 1 on at

Like (1)

Report

Power BI Sales App, Month-To-Date report shows Fiscal Year although set to Standard Calendar in BC.

Hope this helps as well:https://learn.microsoft.com/en-us/dynamics365/business-central/across-powerbi-install-business-central-apps
Gerardo Rentería Ga... 17,784 Most Valuable Professional on at

Like (1)

Report

Power BI Sales App, Month-To-Date report shows Fiscal Year although set to Standard Calendar in BC.

Hi, good day
I hope this can help you, and give you some hints.

Working with accounting periods and fiscal years - Business Central | Microsoft Learn

Best Regards
Gerardo
Suggested answer

Steven Renders 5,500 Moderator on at

Like (2)

Report

Power BI Sales App, Month-To-Date report shows Fiscal Year although set to Standard Calendar in BC.

Be aware that after changing the setup in BC, it can take some time to refresh into the Power BI report, depending on the refresh shedule...

Here's some documentation:

Power BI apps FAQ - Business Central | Microsoft Learn

Installing Power BI apps for Business Central - Business Central | Microsoft Learn