--- id: video/kOCiyVql0go type: video title: "Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)" summary: "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." tier: official language: en tags: - fabric mirroring - datalake - onelake - power bi apps - multi-company reporting - sql endpoint - synchronization - monitoring - permissions system: reporting review: state: reviewed by: opus at: "2026-10-07T22:44:21.436Z" flags: [] generated: at: "2026-10-07T22:44:21.479Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 453efa4c229e101afa7e21358a83f3bc18dd4202d6fda82d2067609f1dd82827 evidence: - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=19s title: "Business Central Fabric mirroring: preview" date: "2026-10-01T00:00:00Z" commit: null t: 19 quote: this is coming in public preview in version 29.x, likely 9 29.1 - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=19s title: "Microsoft Fabric integration app: preview" date: "2026-10-01T00:00:00Z" commit: null t: 19 quote: this is coming in public preview in version 29.x, likely 9 29.1 - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=19s title: "Mirror database in OneLake: preview" date: "2026-10-01T00:00:00Z" commit: null t: 19 quote: this is coming in public preview in version 29.x, likely 9 29.1 - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=333s title: "Multi-company Power BI apps: announced" date: "2026-10-01T00:00:00Z" commit: null t: 333 quote: In two versions, they will be available uh soon either as code samples or on AppSource - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=19s title: "Synchronization overview and details logs: preview" date: "2026-10-01T00:00:00Z" commit: null t: 19 quote: this is coming in public preview in version 29.x, likely 9 29.1 - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=19s title: "Fabric integration APIs: preview" date: "2026-10-01T00:00:00Z" commit: null t: 19 quote: this is coming in public preview in version 29.x, likely 9 29.1 - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=19s title: "Fabric integration permission sets: preview" date: "2026-10-01T00:00:00Z" commit: null t: 19 quote: this is coming in public preview in version 29.x, likely 9 29.1 - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=19s title: "Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)" date: "2026-10-01T00:00:00Z" commit: null t: 19 quote: this is coming in public preview in version 29.x, likely 9 29.1 - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=48s title: "Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)" date: "2026-10-01T00:00:00Z" commit: null t: 48 quote: OneLake is the foundation for all data in Fabric, and this is where you now have the ability to get Business Central data synchronized - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=82s title: "Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)" date: "2026-10-01T00:00:00Z" commit: null t: 82 quote: We try to make this as simple as 1 2 3. One, set up a mirroring database in Fabric. Two, connect to Business Central. - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=286s title: "Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)" date: "2026-10-01T00:00:00Z" commit: null t: 286 quote: 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 - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=315s title: "Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)" date: "2026-10-01T00:00:00Z" commit: null t: 315 quote: we converted them as well to to work on the Fabric backend. In two versions, they will be available uh soon either as code - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=402s title: "Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)" date: "2026-10-01T00:00:00Z" commit: null t: 402 quote: Almost the same as a single company excepts that you now have a filter on where you can filter as it I want to - kind: video url: https://www.youtube.com/watch?v=kOCiyVql0go&t=427s title: "Introducing: Business Central Integration with Microsoft Fabric (2026 release wave 2)" date: "2026-10-01T00:00:00Z" commit: null t: 427 quote: We lock or we write two types of logs in Business Central for for this export or synchronization. An overview and details links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: kOCiyVql0go channel: yt-microsoft source_name: Microsoft Dynamics 365 Business Central (YouTube) url: https://www.youtube.com/watch?v=kOCiyVql0go published_at: "2026-10-01T00:00:00Z" duration_s: 602 captions: full audience: - administrator - functional consultant - developer - partner chapters: - t: 0 title: Introduction to Business Central Fabric mirroring - t: 82 title: "Setup steps 1-2: Configure mirroring database and connect Business Central" - t: 177 title: "Setup step 3: Specify tables, companies, and start synchronization" - t: 265 title: How data appears in OneLake and SQL endpoint - t: 315 title: Power BI apps for Fabric with single and multi-company versions - t: 427 title: Monitoring the integration from Business Central and APIs - t: 512 title: Monitoring from Fabric and permission sets - t: 564 title: Resources and closing features: - name: Business Central Fabric mirroring status: preview t: 7 verified: true status_source: video - name: Microsoft Fabric integration app status: preview t: 132 verified: true status_source: video - name: Mirror database in OneLake status: preview t: 265 verified: true status_source: video - name: Multi-company Power BI apps status: announced t: 315 verified: true status_source: video - name: Synchronization overview and details logs status: preview t: 427 verified: true status_source: video - name: Fabric integration APIs status: preview t: 499 verified: true status_source: video - name: Fabric integration permission sets status: preview t: 539 verified: true status_source: video objects_mentioned: [] quotes: - t: 19 text: this is coming in public preview in version 29.x, likely 9 29.1 check: exact - t: 48 text: OneLake is the foundation for all data in Fabric, and this is where you now have the ability to get Business Central data synchronized check: exact - t: 82 text: We try to make this as simple as 1 2 3. One, set up a mirroring database in Fabric. Two, connect to Business Central. check: exact - t: 286 text: 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 check: exact - t: 315 text: we converted them as well to to work on the Fabric backend. In two versions, they will be available uh soon either as code check: exact - t: 402 text: Almost the same as a single company excepts that you now have a filter on where you can filter as it I want to check: exact - t: 427 text: We lock or we write two types of logs in Business Central for for this export or synchronization. An overview and details check: exact --- # 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. [Watch on YouTube](https://www.youtube.com/watch?v=kOCiyVql0go) · Microsoft Dynamics 365 Business Central (YouTube) · 2026-10-01 · 10:02 · tier official · reviewed (checked by Opus) ## 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. ## Chapters - [0:00](https://www.youtube.com/watch?v=kOCiyVql0go&t=0s) Introduction to Business Central Fabric mirroring - [1:22](https://www.youtube.com/watch?v=kOCiyVql0go&t=82s) Setup steps 1-2: Configure mirroring database and connect Business Central - [2:57](https://www.youtube.com/watch?v=kOCiyVql0go&t=177s) Setup step 3: Specify tables, companies, and start synchronization - [4:25](https://www.youtube.com/watch?v=kOCiyVql0go&t=265s) How data appears in OneLake and SQL endpoint - [5:15](https://www.youtube.com/watch?v=kOCiyVql0go&t=315s) Power BI apps for Fabric with single and multi-company versions - [7:07](https://www.youtube.com/watch?v=kOCiyVql0go&t=427s) Monitoring the integration from Business Central and APIs - [8:32](https://www.youtube.com/watch?v=kOCiyVql0go&t=512s) Monitoring from Fabric and permission sets - [9:24](https://www.youtube.com/watch?v=kOCiyVql0go&t=564s) Resources and closing ## Features | Feature | Status | At | Evidence | |---|---|---|---| | Business Central Fabric mirroring | preview, demoed | [0:07](https://www.youtube.com/watch?v=kOCiyVql0go&t=7s) | "this is coming in public preview in version 29.x, likely 9 29.1" ([0:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=19s)) | | Microsoft Fabric integration app | preview, demoed | [2:12](https://www.youtube.com/watch?v=kOCiyVql0go&t=132s) | "this is coming in public preview in version 29.x, likely 9 29.1" ([0:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=19s)) | | Mirror database in OneLake | preview, demoed | [4:25](https://www.youtube.com/watch?v=kOCiyVql0go&t=265s) | "this is coming in public preview in version 29.x, likely 9 29.1" ([0:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=19s)) | | Multi-company Power BI apps | announced, demoed | [5:15](https://www.youtube.com/watch?v=kOCiyVql0go&t=315s) | "In two versions, they will be available uh soon either as code samples or on AppSource" ([5:33](https://www.youtube.com/watch?v=kOCiyVql0go&t=333s)) | | Synchronization overview and details logs | preview, demoed | [7:07](https://www.youtube.com/watch?v=kOCiyVql0go&t=427s) | "this is coming in public preview in version 29.x, likely 9 29.1" ([0:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=19s)) | | Fabric integration APIs | preview, demoed | [8:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=499s) | "this is coming in public preview in version 29.x, likely 9 29.1" ([0:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=19s)) | | Fabric integration permission sets | preview | [8:59](https://www.youtube.com/watch?v=kOCiyVql0go&t=539s) | "this is coming in public preview in version 29.x, likely 9 29.1" ([0:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=19s)) | ## Quotes - [0:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=19s) "this is coming in public preview in version 29.x, likely 9 29.1" - [0:48](https://www.youtube.com/watch?v=kOCiyVql0go&t=48s) "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](https://www.youtube.com/watch?v=kOCiyVql0go&t=82s) "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](https://www.youtube.com/watch?v=kOCiyVql0go&t=286s) "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](https://www.youtube.com/watch?v=kOCiyVql0go&t=315s) "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](https://www.youtube.com/watch?v=kOCiyVql0go&t=402s) "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](https://www.youtube.com/watch?v=kOCiyVql0go&t=427s) "We lock or we write two types of logs in Business Central for for this export or synchronization. An overview and details" ## Disclaimers in the video - [0:19](https://www.youtube.com/watch?v=kOCiyVql0go&t=19s) preview: coming in public preview in version 29.x, likely 9 29.1 - [5:33](https://www.youtube.com/watch?v=kOCiyVql0go&t=333s) coming-later: In two versions, they will be available uh soon either as code samples or on AppSource