Analyze data in business intelligence tools

Path: Analytics, business intelligence, and reporting > Analyze data in business intelligence tools · tier official · system reporting · narrative reviewed (checked by Opus)

Overview

Analyzing Business Central data in business intelligence tools means getting the data into external tools. The main guide lists the options: Microsoft Fabric, Power BI, data warehouse extraction, and API access. Start there to choose an approach.

Supporting pages go deeper. One introduces Fabric integration and OneLake as a unified data lake with automatic data governance. Another is the API v2.0 reference, which describes building connect apps on REST APIs and moving from v1.0. A third explains that on-premises installations don’t get the cloud KPIs and Power BI insights of the online version unless they migrate to the cloud.

The section also has performance articles for AL developers. They cover page design, web services, reports, AL coding patterns, data access and testing, and they help developers tune Business Central applications.

Key points

• The main guide lists four routes for analysis: Microsoft Fabric, Power BI, data warehouse extraction, and API access.
• Fabric integration uses OneLake as a unified data lake, with data lineage, data protection, certification and catalog integration.
• API v2.0 is a REST API for building connect apps with third-party services. The reference covers API pages, operations, code examples and the transition from v1.0.
• On-premises Business Central lacks the cloud-based KPIs and Power BI insights of the online version. Cloud migration is needed to get them.
• AL performance articles cover page background tasks, Edit-in-Excel performance, query object optimization and partial records.
• They also cover table extension impact analysis and event subscription performance.
• Some performance guidance is tied to 2021 release wave 2 and 2023 release waves 1 and 2.

Subtopics

• Microsoft Fabric (5 pages)

More Learn pages

• Analyze Data in Business Intelligence Tools: Provides an overview of how external Business Intelligence tools can interact with Business Central data.
• API (v2.0) for Dynamics 365 Business Central: Reference content for the API (v2.0) endpoint for integration with Dynamics 365 Business Central.
• Intelligent insights and cloud migration (on-premises only): In Business Central online, you have access to other online services, and you can get intelligent insights that are based on Azure AI, for example. Read on if you’re considering to migrate from on-premises to the cloud.
• Performance Articles for AL Developers: Learn how to write efficient AL code, pages, reports, and web services, and use tools like the AL Profiler to improve performance in Business Central.

Videos and posts

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

• Business Central Data Mirroring to Microsoft Fabric Is Coming (community post): “simplifies analytics architecture for enterprise data platforms”

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 4010 “Intelligent Cloud”
• Page 6316 “Sustainability Report Power BI” · captioned “Sustainability Report (Power BI)” · via Microsoft Fabric
• Page 6317 “To Net Zero Carbon Power BI” · captioned “Journey to Net Zero Carbon (Power BI)” · via Microsoft Fabric

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