Use new dedicated APIs for financial reporting

Enabled for Public preview General availability
Users, automatically Sep 1, 2022 Oct 1, 2022

Business value

With dedicated APIs for finance reporting, it's easier to create your own Excel-based financial reports. You can also consume the APIs in Power BI through the Business Central Power BI Connector.

Feature details

The new APIs and datasets are created for selected data. The first datasets dedicated consist of data for:

  • General Ledger data, including G/L budgets and Dimensions
  • Accounting Periods and Business Units
  • Customers, Vendors, and Ledger entries, including detailed Ledger entries
  • Webhook subscriptions and entity definitions

With these APIs it's easy to get data from Business Central for financial reporting in Excel, Power BI, or other reporting tools.

The APIs can be found under Advanced APIs and are called reportsFinance/beta.

The new APIs for financial reporting

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

See also

Analyzing Financial Statements in Microsoft Excel (docs)