Administrator
Administrator guidance for Power BI integration with Business Central. It covers how to enable the integration (licensing, API pages, OData web services, online and on-premises setup) and how the integration components and architecture fit together.
Path: Integration > Integrating with Microsoft Power Platform > Integrating with Microsoft Power BI > Administrator · tier official · system reporting · narrative reviewed (checked by Opus)
Overview
This section is for administrators who set up Power BI with Business Central. It has two pages: one on enabling the integration, and one on the components and architecture behind it.
The enabling page covers the Power BI free and Pro licenses, how Business Central data is exposed through API pages and OData web services, and configuration for online and on-premises deployments. It also mentions dataflows and Power BI apps.
The architecture page explains how reports are created and viewed in Power BI Desktop and Power BI Service. It lists the Power BI connectors, embedded reports, report management, default reports and Power BI apps on the marketplace. For online environments it notes that read-only database replicas are used. Start with the architecture page for context, then use the enabling page for setup.
Key points
- Power BI integration lets you create and view reports with Power BI Desktop and Power BI Service.
- Both the Power BI free license and the Pro license are covered in the setup page.
- Business Central data is exposed to Power BI through API pages and OData web services.
- Setup differs for online and on-premises deployments.
- Online environments use read-only database replicas for Power BI reporting.
- Components include Power BI connectors, embedded reports, report management and default reports.
- Power BI apps are available on the marketplace, and dataflows are part of the setup topic.
- The pages cite versions 2022 (enabling) and 2021 release wave 2 (architecture).
Learn pages
- Enabling Power BI integration with Business Central: Learn how to set up the connection to Power BI. With Power BI reports, you can get insights, business intelligence, and key performance indicators from your data.
- Power BI integration component and architecture overview for Business Central| Microsoft Docs: Learn about the different aspects of Power BI integration with Business Central.
Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.