Business Central Microsoft Fabric integration is one of the headline features of the 2026 release wave 2. Business Central can now mirror its data directly into Microsoft Fabric, so your ERP data lands in OneLake, ready for Power BI and the rest of the Fabric tools, without building your own export pipeline.
Microsoft introduced the feature in a short launch video, embedded below. In this article we walk through what it shows: how the setup works, what your data looks like once it is in Fabric, the Power BI apps that come with it, and how administrators can monitor the synchronization.
Good to know: Microsoft presents this as a public preview, expected in version 29.x, most likely 29.1. Preview features can still change before general availability.
What Is Microsoft Fabric, and Why Mirror Business Central Data There?
Microsoft Fabric is Microsoft’s data and analytics platform. It brings tools such as Power BI, Data Factory and data analytics together on one foundation, with Copilot, security and governance built in. At the center is OneLake, the single storage layer for all data in Fabric.
With the new mirroring feature, Business Central data is synchronized into OneLake on an ongoing basis. Until now, Microsoft’s Power BI apps for Business Central read their data through APIs, and partners who wanted BC data in a data lake typically built their own export, for example with the open-source bc2adls tool. Mirroring makes this a standard, supported part of Business Central.
How to Set Up Business Central Microsoft Fabric Mirroring
Microsoft describes the setup as “as simple as one, two, three”. Here are the three steps shown in the video.
Step 1: Create a mirrored database in Fabric
First, decide where the data should go. In the Fabric portal, create a new mirrored database and give it a name. Once Fabric has finished provisioning it, copy the connection details. You will need them in Business Central in the next step.
Step 2: Connect Business Central to Fabric
In Business Central, a new app handles the Microsoft Fabric integration. On its connection setup, enter which Fabric workspace and which open mirroring database to use. Then run the Connect to Fabric action from the Fabric menu, which puts the required infrastructure in place. A Test Connection action lets you confirm that Business Central can write data to your Fabric environment.
Step 3: Choose tables and companies, then start
Finally, specify what to synchronize. Under configuration in the same app, you choose two things:
- Which tables to mirror.
- Which companies to include: one company or several.
Instead of picking tables by hand, you can also import a configuration package. Microsoft provides one with the tables its standard Power BI apps need, and ISV solutions can supply their own packages for the tables they depend on. Then click Start Synchronization, and the data starts flowing.
What Your Business Central Data Looks Like in Fabric
In the mirrored database, your tables appear as they are defined in AL, Business Central’s development language. Under the hood they are stored as Delta-Parquet files in OneLake, but Fabric adds a SQL endpoint on top. That means you or your report builders can write ordinary SQL queries against Business Central data as if it were a normal SQL database.
From there, the data is available to the wider Fabric toolset, such as Power BI, Data Factory and data analytics, and can be combined with data from other systems.
Ready-Made Power BI Apps, Including Multi-Company Reporting
Microsoft has also converted its nine Power BI apps for Business Central to run on the Fabric back end. According to the video they will be available soon, either as code samples or on AppSource, in two versions:
- Single-company versions, similar to the Power BI apps you know today.
- Multi-company versions, where the same report shows data across several companies, with a filter to choose all companies or just some of them.
The multi-company versions are the interesting part for groups running several Business Central companies. In the video, Microsoft shows finance and sales reports where you simply pick which companies to include, instead of maintaining separate reports per company.
Monitoring the Integration
For administrators, Business Central writes two types of logs for the synchronization:
- Synchronization Overview, a summary of each run.
- Synchronization Details, showing exactly what was pushed to Fabric.
Both are found under the monitoring menu in the app, with ready-made views for all entries or just the errors. You can also open them in analysis mode to build your own quick reports. The same logs are pushed to Fabric, so you can monitor from that side too, and everything in the setup and monitoring is also exposed through six Fabric-related APIs, listed on the API overview page in Business Central.
Access is controlled with dedicated permission sets: one for activating the integration, one for administering the export, and a read-only set for viewing the configuration. Not everyone in your organization can switch it on.
NAV SEAL’s Take: Should You Use It?
For companies that already report heavily in Power BI, or want to combine Business Central data with other sources, this is a big step forward. A supported, built-in path to OneLake removes much of the custom work that BC-to-data-lake projects used to need. A few practical points before you jump in:
- It is a preview. Try it in a sandbox environment first, and expect details to change before general availability.
- Fabric is a separate Microsoft service. You need a Fabric workspace to mirror into, so check the Fabric licensing and capacity side with your Microsoft partner before planning a rollout.
- Be selective with tables. Start with the tables your reports actually need, or use Microsoft’s configuration package for the standard Power BI apps, rather than mirroring everything.
- Decide who owns it. Use the permission sets to keep setup and administration with the right people, and make checking the error log part of someone’s routine.
Microsoft’s documentation hub for Business Central analytics, including a Microsoft Fabric article, is at aka.ms/bcAnalytics. For more on what is coming in each release, see our Release News and our guide to Business Central wave releases.
Need help with this in your Business Central?
NAV SEAL’s specialists set this up for clients every week. Whether you’re getting started, fixing a setup that never quite worked, or moving data from another system, we can help.
One Comment
Comments are closed.