Enable Power BI connector to work with Business Central APIs, instead of with web services only

Important

This content is archived and is not being updated. For the latest documentation, go to New and Planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users, automatically Mar 24, 2021 Jun 14, 2021

Business value

Faster and more robust data analysis is key for any modern organization. While Business Central already offers tight integration with Power BI, it relies strictly on web services. This feature enables more modern and richer data sources for your reports hosted in Power BI.

Feature details

With this feature, instead of having to enable pages as web services, you can now create Power BI reports and dashboards using the modern Business Central APIs, including both the built-in APIs v2.0 provided with Business Central and custom APIs created by partners or developers. This gives customers and partners access to better and faster data analytics in Power BI.

The new connector for Power BI has the following features:

  • Supports v2.0 APIs from Business Central.
  • Supports custom API pages.
  • Continues to support web services.
  • Is fully backward-compatible.
  • Works with any Business Central online version.
  • Delivers better performance just by using APIs.

Learn more at Business Central and Power BI

Dataset picker in Power BI

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.