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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Steven Renders 5,672 Moderator on at

Like (2)

Report

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

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,966 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps as well:https://learn.microsoft.com/en-us/dynamics365/business-central/across-powerbi-install-business-central-apps

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No