The preview environment for Dynamics 365 Business Central 2022 release wave 2 (BC21) is available. Learn more: Link.
I will continue to test and share some new features that I hope will be helpful.
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.https://docs.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/excel-layouts–new-report-datasets-excel-reporting
As you might know, Business Central online comes available with a set of built-in APIs, which you can use to get data for the most common business entities, like customers, items, sales orders, and more. No extra work or setup is required to use these APIs as a data source for Power BI reports. For more information about these APIs, see Business Central API V2.0.
Now 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.
Let’s see more details.
In Power BI:
Now you can find a new API group under Advanced APIs, microsoft/reportsFinance/beta.
The following new APIs have been added.
These new APIs are provided by a new extension, API Reports – Finance.
For example, page 30302 “API Finance – Dimension Values”
1. Of course this new APIs can also be used in products such as Power Automate.
2. This API group is not available in BC 20.5.
3. API page type cannot be extended by creating a page extension object. More details: API Page Type
4. Business Central online also supports custom APIs. Application developers of Business Central solutions can create their own API pages and queries and package them into apps. You then install the apps on your tenant. Once installed, you use the API pages for your Power BI reports, like you’d do with the built-in APIs (v2.0). For more information about how to create an API by exposing pages or queries, see Developing a Custom API.
Give it a try!!!😁
Hope this will help.
Thanks for reading.