Edit

Share via

Integrating Business Central with Microsoft Power Platform

  • Article

Integrating Business Central with Microsoft Power Platform, offers a solution that enhances business productivity and efficiency. It provides a set of tools that enable you to analyze data, build solutions, automate processes, and create virtual agents. By integrating Microsoft Power Platform with Business Central, you can apply the data and business logic of Business Central, and benefit from the analytical and automation capabilities of Microsoft Power Platform. This article explains you can integrate Business Central with Microsoft Power Platform.

Business Central connector for Power Platform

A connector is a proxy or a wrapper around an API that allows the user of the connector to talk to the underlying service. Business Central has its own connector that allows Power Platform products such as Power Automate, Power Apps, and Logic apps to communicate with Business Central through REST APIs (this is another reason for using REST APIs compared to OData/SOAP enabled pages/queries/codeunits).

Shows how the Power Platform connector integrates to Business Central

For more information, see Power Platform Connectors Overview and Dynamics 365 Business Central Connector in the Power Platform documentation.

Integrating Business Central with Microsoft Power Apps

You can integrate Business Central with Microsoft Power Apps by using the Business Central connector for Power Platform. With Power Apps, you have the flexibility to build the perfect solution for your business domain—one that uses Business Central data and processes and maximizes your productivity. With Power Apps custom UI, AI builder, and augmented-reality (AR)/mixed-reality (MR) technologies, you can take your business to the next level with cutting-edge innovation and customized UI.

For more information, see Integrating with Microsoft Power Apps overview

Integrating Business Central with Microsoft Power Automate

You can integrate Business Central with Microsoft Power Automate by using the Business Central connector for Power Platform. With Power Automate, you can set up and use flows to connect business-process tasks performed by different users. System tasks, such as automatic posting, can be included as steps in flows, preceded or followed by user tasks. Requesting and granting approval to create new records are typical flow steps.

For more information, see Integrating with Microsoft Power Automate overview

Integrating Business Central with Microsoft Power BI

You can integrate Business Central with Microsoft Power BI in two ways:

  • Connect a Power BI semantic model to Business Central to read data.
  • Embed a Power BI report, page, or visual in the Business Central client.

How to connect a Power BI semantic model to Business Central to read data

Business Central integrates with Power BI through a connector using OData. The connector can read data from API pages/queries and from UI pages exposed as OData web services.

Image alt text.

For more information, see Power BI integration overview.

How to embed a Power BI report, page, or visual in the Business Central client

Business Central supports that a Power BI report, page, or visual can be embedded in the Business Central client by using an iframe.

There are two ways that a Power BI report, page, or visual can be added to a page in the Business Central client:

  1. A user can embed a Power BI report, page, or scorecard on pages that include a Power BI part. For more information, see Working with Power BI Reports in Business Central.
  2. A developer can programmatically add them from AL. For more information, see Adding Power BI Report parts to pages.

Integrating Business Central with Microsoft Power Pages (preview)

You can integrate Business Central with Microsoft Power Pages by using virtual tables in Dataverse. With Power Pages, you can allow unlicensed external users to access data stored in Business Central online.

Shows how data virtualization works between Business Central and Dataverse

For more information, see Integrating with Microsoft Power Pages (preview).

Business Central connector for Power Platform
Integrating with Microsoft Power Apps overview
Integrating with Microsoft Power Automate overview
Integrating with Microsoft Power Pages (preview)
Integrating with Microsoft Power BI
How users can embed Power BI Reports in Business Central
How AL developers can add Power BI Reports to pages
Business Central integrations overview