Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)
Business Central Fabric mirroring, shown as coming in public preview in version 29.x (likely 29.1): live sync of BC tables to OneLake as Delta Parquet, queried via a SQL endpoint. Covers the three-step setup, Power BI apps on Fabric, sync logs, six APIs and permission sets.
- Introduction to Business Central Fabric mirroring
- Setup steps 1-2: Configure mirroring database and connect Business Central
- Setup step 3: Specify tables, companies, and start synchronization
- How data appears in OneLake and SQL endpoint
- Power BI apps for Fabric with single and multi-company versions
- Monitoring the integration from Business Central and APIs
- Monitoring from Fabric and permission sets
- Resources and closing
Overview
The video introduces Business Central integration with Microsoft Fabric through mirroring. Business Central data is synchronized to OneLake, the foundation for data in Fabric. Tables arrive as Delta Parquet files in an open mirroring database and are exposed as SQL tables through a SQL endpoint. Setup is described as three steps: set up a mirroring database in Fabric, connect Business Central to it, then choose tables and companies and start synchronization.
It also covers Power BI apps converted to run on the Fabric backend, with single-company and multi-company versions, and how to monitor the integration. Monitoring uses two logs (overview and details) in the Business Central client, through APIs, and in Fabric. The video ends with the permission sets that control who can set up and manage the integration. The speaker says the feature is coming in public preview in version 29.x, likely 29.1.
Key points
- Fabric mirroring is stated as coming in public preview in version 29.x, likely 29.1.
- Setup is described as three steps: create a mirroring database in Fabric, connect Business Central to it, then specify tables and companies and start synchronization.
- The Microsoft Fabric integration app needs a connection string set up manually from Fabric. Configuration packages can be used for ISV solutions.
- Synced tables are Delta Parquet files in the open mirroring database in OneLake, not native SQL tables. The SQL endpoint abstracts them as SQL tables.
- Nine Power BI apps are being delivered on the Fabric backend, in single-company and multi-company versions. The multi-company version adds a company filter. They are expected soon as code samples or on AppSource.
- Synchronization writes an overview log and a details log in Business Central. They are available in the client, through APIs and in Fabric. The details page can be used in analysis mode for custom reports.
- Six new APIs cover setup and monitoring of the Fabric integration. Permission sets separate activation, administration and read-only configuration access.
Features
| Feature | Status | At | Evidence |
|---|---|---|---|
| Business Central Fabric mirroring | preview, demoed | 0:07 | “this is coming in public preview in version 29.x, likely 9 29.1” (0:19) |
| Microsoft Fabric integration app | preview, demoed | 2:12 | “this is coming in public preview in version 29.x, likely 9 29.1” (0:19) |
| Mirror database in OneLake | preview, demoed | 4:25 | “this is coming in public preview in version 29.x, likely 9 29.1” (0:19) |
| Multi-company Power BI apps | announced, demoed | 5:15 | “In two versions, they will be available uh soon either as code samples or on AppSource” (5:33) |
| Synchronization overview and details logs | preview, demoed | 7:07 | “this is coming in public preview in version 29.x, likely 9 29.1” (0:19) |
| Fabric integration APIs | preview, demoed | 8:19 | “this is coming in public preview in version 29.x, likely 9 29.1” (0:19) |
| Fabric integration permission sets | preview | 8:59 | “this is coming in public preview in version 29.x, likely 9 29.1” (0:19) |
Quotes
- 0:19 “this is coming in public preview in version 29.x, likely 9 29.1”
- 0:48 “OneLake is the foundation for all data in Fabric, and this is where you now have the ability to get Business Central data synchronized”
- 1:22 “We try to make this as simple as 1 2 3. One, set up a mirroring database in Fabric. Two, connect to Business Central.”
- 4:46 “They’re actually not SQL tables, they’re Delta Parquet files, but uh that abstraction has been like uh that has been abstracted away in the”
- 5:15 “we converted them as well to to work on the Fabric backend. In two versions, they will be available uh soon either as code”
- 6:42 “Almost the same as a single company excepts that you now have a filter on where you can filter as it I want to”
- 7:07 “We lock or we write two types of logs in Business Central for for this export or synchronization. An overview and details”