Integrating with Microsoft Power BI

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

Overview

This area covers how Business Central works with Power BI. It includes the built-in Power BI apps, reports built in Power BI Desktop, and reports shown inside Business Central pages. The introduction page gives the overall picture and the roles involved.

The subtopics split the work by role. Administrators enable the integration (licensing, API pages, OData web services, online and on-premises setup) and learn how the components fit together. Report creators build reports with the connector, APIs and OData web services, and prepare them for Power BI FactBoxes on list pages.

Further pages cover embedding reports, scorecards and dashboards with the Power BI embed framework, extracting data with ETL patterns, and tuning dataset load performance. Start with the introduction, then go to the Administrator or Report creator subtopic that matches your role.

Key points

• The introduction page describes built-in Power BI apps, Power BI Desktop integration, report embedding and KPI tracking across roles.
• Administrators enable the integration, covering licensing, API pages, OData web services, and online and on-premises setup.
• Report creators build reports in Power BI Desktop using the connector, APIs and OData web services.
• Reports can be prepared to appear in Power BI FactBoxes on list pages.
• Embedding uses the Power BI embed framework with pages such as Power BI Embedded Report Part and Power BI Element Addin Host; context is set with SetCurrentListSelection and SetPageContext.
• Data extraction covers ETL, historical and delta loads using API queries filtered on SystemModifiedAt, read scale-out, Azure Data Factory and Power BI dataflows.
• Dataset load performance improves by loading only the data you need through APIs and web service endpoints.
• Web service telemetry can monitor usage, performance and errors.

Subtopics

• Administrator (2 pages)
• Report creator (2 pages)

More Learn pages

• Embed Power BI reports in pages: Explains how to display Power BI reports on pages in Business Central
• Extract data from Business Central: Explains how to extract data from Business Central with different tools
• Introduction to Business Central and Power BI: Get an overview of using Power BI to get insights from your Business Central data.
• Power BI Dataset Load Performance: Learn about how to tune the performance of Power BI dataset load time based on Business Central web services and APIs

Videos and posts

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

• Step-by-Step Guide to Business Central API Queries (community post): “Query APIs can be directly connected to Power BI using the Dynamics 365 Business Central connector”
• Quick Tip: How Can You Download the Standard Business Central Power BI Reports? (community post): “Standard Power BI reports for Business Central are available through official Microsoft Power BI template apps”
• Quick Tip: Troubleshooting Business Central Power BI Reports: My 5-Minute Checklist (community post): “Business Central Power BI issues stem from configuration problems rather than Power BI itself”
• What’s New: Business Central Integration with Power Platform including Power BI(2024 release wave 2) (video): “Power BI Embedded Reports with Full Capabilities; Power BI Report Page Bookmarking”
• What’s New: Business Central Integration with Power Platform (2023 release wave 2) (video): “Power BI embed experience improvements; Power BI scorecard support in Business Central”

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)”
• Page 6317 “To Net Zero Carbon Power BI” · captioned “Journey to Net Zero Carbon (Power BI)”

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