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.]
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
- This is a production-ready preview feature.
- Production-ready previews are subject to supplemental terms of use.
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:
- Creates an open mirrored database in a Fabric workspace.
- Creates a service principal in Microsoft Entra for the Microsoft-provided Dynamics 365 Business Central Fabric Export application.
- Grants the application's service principal access to the Fabric workspace.
- Connects Business Central to the workspace and database.
- Selects the Business Central companies and tables to synchronize.
- 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.
Related information
Analyze data in business intelligence tools
Using Power BI with Business Central
Extract data from Business Central
Microsoft Fabric documentation