Reporting

Important

This content is archived and is not being updated. For the latest documentation, go to What's new and planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

With 2022 release wave 1, we introduced Excel layouts for reports. In 2022 release wave 2, we continue to improve this experience.

When a business user runs a report with an Excel layout, they can now choose the Excel layout in the report's request page. For example, if a report has several Excel layouts, the user can choose the exact layout they want when they run the report.

In addition to the Excel layout capability, we'll release a new set of APIs for the finance area that can be used in both Excel and Power BI. This way, users can create their own more detailed analysis on data from the general ledger and G/L budgets with dimensions. We'll provide new template Power BI Desktop files with examples based on the new API. The files will be published to the BCTech Samples GitHub repo for users who want to get started with reporting in Power BI. The Power BI files contain a set of standard financial reports and a dashboard with financial KPIs and aggregated general ledger info.