Integrating with Microsoft Power Platform

Path: Integration > Integrating with Microsoft Power Platform · tier official · system platform · narrative reviewed (checked by Opus)

Overview

This section covers how Business Central works with the Power Platform products. The entry page gives an overview of Power Apps, Power Automate, Power BI, Power Pages and Copilot Studio, and explains that integration happens through the Business Central connector and virtual tables.

Each product has its own subtopic. The Power Apps pages cover building apps on Business Central data, canvas app best practices, GitHub samples and lifecycle management. The Power Automate pages cover admin setup, automated and instant flows, and flow management. The Power BI pages cover enabling the integration, report authoring, embedding, ETL data extraction and dataset load performance. The Copilot Studio pages cover the Business Central MCP Server and agents built on the connector or the MCP server.

Power Pages on virtual tables is described on its own page in this section. It is a preview feature that lets unlicensed external users reach Business Central online data through portals. Start with the overview page, then go to the subtopic for the product you need.

Key points

• The overview page lists the integration points: Business Central connector, Power Apps, Power Automate flows, Power BI embedding, Power Pages virtual tables and Copilot Studio agents.
• Power Apps: build apps on Business Central data, follow canvas app best practices, use GitHub sample apps, and apply application lifecycle management to Power Platform solutions.
• Power Automate: administrators set up access and permissions, create automated and instant flows, and manage existing flows. Topics include triggers, actions and Teams integration.
• Power BI: enable the integration, build reports on Business Central data, embed reports in pages, extract data for ETL, and improve dataset load performance.
• Copilot Studio: configure the Business Central MCP Server and build agents that use the Business Central connector or the MCP server.
• Power Pages on virtual tables (preview) gives unlicensed external users access to Business Central online data through Dataverse virtual tables.
• Power Pages supports anonymous and authenticated access, synthetic relations, lookup columns, basic forms and grid configuration. List and subgrid editing is available from 2023 release wave 2 (version 23.1).

Subtopics

• Integrating with Microsoft Power Apps (4 pages)
• Integrating with Microsoft Power Automate (5 pages)
• Integrating with Microsoft Power BI (8 pages)
• Integrating with Microsoft Copilot Studio (2 pages)

More Learn pages

• Integrating Business Central with Microsoft Power Platform: Learn how to integrate Business Central with Microsoft Power Platform using connectors to enhance productivity.
• Power Pages on virtual tables: How-to description

Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

• #2346 Pin all actions that are not currently pinned (code change): “Unpinned action references are pinned in Power Platform action.yaml files”
• #12242 29.x: Removing the restriction of deploying Power BI reports only to evaluation companies (code change): “Power BI report deployment is no longer limited to evaluation companies”

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 6316 “Sustainability Report Power BI” · captioned “Sustainability Report (Power BI)” · via Integrating with Microsoft Power BI
• Page 6317 “To Net Zero Carbon Power BI” · captioned “Journey to Net Zero Carbon (Power BI)” · via Integrating with Microsoft Power BI
• Page 8350 “MCP Config List” · captioned “Model Context Protocol (MCP) Server Configurations” · via Integrating with Microsoft Copilot Studio
• Page 8351 “MCP Config Card” · captioned “Model Context Protocol (MCP) Server Configuration” · via Integrating with Microsoft Copilot Studio
• Page 8359 “MCP Config Warning List” · captioned “MCP Configuration Warnings” · on Table 8352 “MCP Config Warning” · via Integrating with Microsoft Copilot Studio

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.