Microsoft Power Platform

Path: Integrate with other applications > Microsoft Power Platform · tier official · system platform · narrative reviewed (checked by Opus)

Overview

This section explains how Business Central works with the Power Platform. The top-level page introduces the Business Central connector, Power Apps custom solutions, Power Automate flows, Power BI semantic models and reporting, and Power Pages virtual tables, with Dataverse as the shared layer for some scenarios.

Each service has its own subtopic. Power Apps covers building apps on Business Central data through the connector, API tables, custom APIs and canvas apps. Power Automate covers no code/low code workflows, flow types, triggers and actions, and troubleshooting. Power BI is the largest area: licensing, enabling and connecting online and on-premises environments, building reports in Power BI Desktop, showing reports in FactBoxes, and the built-in Power BI apps.

A separate page describes Power Pages on virtual tables (preview), which lets unlicensed external users reach Business Central online data through portals. Start with the overview page to pick the service, then go to the matching subtopic for setup details.

Key points

• Power Automate flows use the Business Central connector, and Power Apps connects to a Business Central environment through the Power Apps connector.
• Power Apps: connect to a Business Central environment, use API tables and custom APIs, and build canvas apps. Options include custom UI, AI Builder, and augmented or mixed reality.
• Power Automate: build no code/low code workflows with triggers and actions, use flows in Business Central, and troubleshoot automated flows.
• Power BI: covers licensing, enabling online and on-premises connections, Power BI Desktop reports, FactBox reports, and built-in Power BI apps.
• Power Pages on virtual tables is a preview feature that lets unlicensed external users reach Business Central online data through portals running on Dataverse virtual tables.
• Power Pages supports anonymous and authenticated access, synthetic relations, lookup columns, and basic forms. List/subgrid editing is supported from 2023 release wave 2, and the page also mentions version 23.1.
• Start at the top-level integration page, which covers the connector, Power Apps, Power Automate, Power BI semantic models and reports, and Power Pages virtual tables, then go to the subtopic for the service you need.

Subtopics

• Microsoft Power Apps (2 pages)
• Microsoft Power Automate (3 pages)
• Microsoft Power BI (8 pages)

More Learn pages

• Integrate with Microsoft Power Platform: Learn how to integrate Business Central with the Microsoft Power Platform
• 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.

• #12189 Removing the restriction of deploying Power BI reports only to evaluation companies (code change): “Power BI report deployment now works with regular 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 1500 “Workflows” · on Table 1500 “Workflow Buffer” · via Microsoft Power Automate
• Page 6316 “Sustainability Report Power BI” · captioned “Sustainability Report (Power BI)” · via Microsoft Power BI
• Page 6317 “To Net Zero Carbon Power BI” · captioned “Journey to Net Zero Carbon (Power BI)” · via Microsoft Power BI
• Page 36951 “PowerBI Reports Setup” · captioned “Power BI Reports Setup” · on Table 36951 “PowerBI Reports Setup” · via Microsoft Power BI

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