Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
[This article is prerelease documentation and is subject to change.]
After you configure data mirroring from Business Central to Microsoft Fabric, use the Microsoft Fabric Mirroring Setup page to choose the data to synchronize and control synchronization.
Important
- This feature is planned to become available as a production-ready preview in October 2026. Delivery timing and functionality might change.
- Production-ready previews are subject to supplemental terms of use.
Assign permissions for data mirroring
Assign permission sets according to each person's responsibilities.
| Permission set | Use |
|---|---|
| MS Fabric Mirroring - Admin | Set up the connection, select companies and tables, manage configuration packages, control synchronization, and view monitoring information. |
| MS Fabric Mirroring - Activate | Activate, deactivate, and reapply configuration packages. |
| MS Fabric Mirroring - Read | View synchronization overview and detail information. |
Select companies
- Open the Microsoft Fabric Mirroring Setup page.
- Select Configuration > Companies.
- Select Add company, and then select a company.
- Repeat the previous step for each company to synchronize.
Clear the Enabled field to temporarily skip a company without removing its configuration.
For each enabled company, synchronize tables that store data per company. Synchronize tables that don't store data per company once.
Select tables
You can select up to 1,000 tables for synchronization.
- Open the Microsoft Fabric Mirroring Setup page.
- Select Configuration > Tables.
- Select Add table.
- Select one or more Business Central tables.
Business Central assigns a Fabric entity name and identifies whether each table stores data per company. Use the Fabric Schema Type field to choose whether the table belongs to the data or logging schema.
Use configuration packages
Configuration packages let you add a curated set of tables instead of selecting tables individually. The Microsoft Fabric Mirroring app includes the MS-STD package, which contains 256 standard Business Central tables for analytics scenarios.
Open the Microsoft Fabric Mirroring Setup page.
Select Configuration > Import/Export Configuration.
Select a package, and then use one of the following actions:
- Activate: Adds the package's tables to the synchronization list.
- Deactivate: Removes the package's table selections. A table remains selected if you selected it manually or if it's included in another active package.
- Reapply: Adds changes from a newer package version. Reapply doesn't remove stale selections. Deactivate and activate the package to fully align the selection with the latest package definition.
You can also import or export package definitions as JSON files. You must deactivate a package before you delete it.
Note
Activating or reapplying a package can't increase the total selection beyond the 1,000-table limit.
Configure synchronization behavior
Use the following fields on the Microsoft Fabric Mirroring Setup page:
| Field | Description |
|---|---|
| Minutes Between Exports | Specifies the interval between continuous synchronization runs. A change takes effect with the next run. |
| Max Consecutive Failed Runs | Specifies how many consecutive failures are allowed before synchronization stops. Enter a value from 1 through 5. The default is 2. |
| Fabric Data Namespace | Specifies the Fabric schema for synchronized business data. The default is BusinessCentral. |
| Fabric Logging Namespace | Specifies the Fabric schema for synchronization logs. The default is BusinessCentral_log. |
You can change the namespace fields only before the mirroring setup is complete.
Start, stop, or reset synchronization
| Action | Result |
|---|---|
| Start synchronization | Enables change tracking on the selected tables and starts recurring synchronization. If a synchronization run is already active, Business Central doesn't start another run. |
| Stop synchronization | Cancels an in-progress run and pauses recurring synchronization. The Fabric connection and synchronization state are preserved so that you can resume later. |
| Reset | Cancels in-progress work, removes the tenant's mirroring resources, resets all watermarks, and deletes the synchronization summary and detail records. |
Setup, start, stop, and reset requests run asynchronously. Use the monitoring pages to confirm that an operation finished.
You can't change the Fabric workspace or open mirrored database while the Export Enabled field is selected. Select Reset to clear the connection before you select a different destination.