Edit

Data mirroring to Microsoft Fabric from Business Central

[This article is prerelease documentation and is subject to change.]

Data mirroring connects Business Central online to an open mirrored database in Microsoft Fabric. You select the companies and tables to synchronize. Business Central then replicates an initial snapshot and ongoing changes into OneLake.

Important

In Fabric, Business Central data is stored in OneLake in Delta Parquet format. Fabric IQ, Power BI, Data Factory, and other analytics experiences can use the synchronized data without repeatedly reading it from Business Central APIs.

Choose when to use data mirroring

Use data mirroring when your organization wants a managed way to make Business Central data available in Fabric for analytics and data engineering. The integration supports:

  • Multiple Business Central companies.
  • Up to 1,000 selected Business Central tables across manual selections and configuration packages.
  • Initial snapshot and incremental synchronization.
  • A Microsoft configuration package with a curated set of standard tables.
  • Synchronization monitoring in Business Central, through APIs, and from Fabric.

Learn more about choosing an extraction method in Extract data from Business Central.

Understand the mirroring flow

An administrator completes the following high-level tasks:

  1. Creates an open mirrored database in a Fabric workspace.
  2. Creates a service principal in Microsoft Entra for the Microsoft-provided Dynamics 365 Business Central Fabric Export application.
  3. Grants the application's service principal access to the Fabric workspace.
  4. Connects Business Central to the workspace and database.
  5. Selects the Business Central companies and tables to synchronize.
  6. Starts synchronization and monitors each run.

The setup and synchronization operations run asynchronously. Business Central records an overview for each run and details for each company and table.

Connect to Fabric prepares the connection. Start synchronization requests continuous export of the selected data. Finishing the assisted setup guide doesn't start synchronization.

Get started

Task Learn more
Prepare Fabric and connect Business Central Set up data mirroring from Business Central to Microsoft Fabric
Select companies and tables, use configuration packages, and control synchronization Manage Business Central data synchronization with Fabric
Check synchronization runs and resolve common problems Monitor and troubleshoot Fabric synchronization
Find answers about authentication, data selection, and limits FAQ about mirroring Business Central data to Microsoft Fabric

Use mirrored data in Fabric

An open mirrored database includes a SQL analytics endpoint for querying its tables. You can also use Fabric data engineering, data science, and Power BI experiences with the data in OneLake. Learn more in Open mirroring in Microsoft Fabric.

Review who can access the mirrored data in Fabric. Grant access to the mirrored database and its SQL analytics endpoint according to your organization's requirements. Learn more in Share your mirrored database and manage permissions.

Analyze data in business intelligence tools
Using Power BI with Business Central
Extract data from Business Central
Microsoft Fabric documentation

Find free e-learning modules for Business Central here