For years, getting Business Central data into a proper analytics platform meant building something. An export job, a data pipeline, a nightly refresh, and someone on the team who understood how it all hung together. When that person went on leave, so did your reporting.
With 2026 release wave 2, Microsoft has changed that. Business Central can now mirror its data directly into Microsoft Fabric, with no pipeline to build and no middleware to maintain. The feature arrives in public preview in version 29.x (most likely 29.1), and it is one of the most useful additions to Business Central in a long time.
Here is what it does, how it works, and where we think it makes the biggest difference.
What mirroring actually means
Microsoft Fabric is Microsoft's all-in-one data platform. Power BI, Data Factory, Synapse-style analytics and Copilot all sit on top of a single storage layer called OneLake.
Mirroring keeps a copy of your Business Central tables in OneLake and keeps it in sync. The data lands as Delta-Parquet files, the open format the rest of Fabric reads natively. Fabric also puts a SQL endpoint over those tables, so your analysts can write ordinary SQL queries against Business Central data as if it were a normal database, without touching your production environment.
Setup really is three steps
Microsoft has kept this simple and having walked through it, we agree.
- Create a mirrored database in Fabric. In your Fabric workspace, choose New, then Mirrored Database, give it a name and let it provision. Copy the connection details.
- Connect Business Central. In the new Microsoft Fabric integration app in Business Central, enter the workspace and mirrored database details, then run Connect to Fabric. A Test Connection action confirms Business Central can write to your Fabric environment.
- Choose your tables and companies, then start. Pick the tables you want and the companies you want them from. Click Start Synchronization and you are done.
You can also import a configuration package instead of picking tables by hand. That is how Microsoft's own Power BI apps, and ISV solutions with their own reporting, will tell you exactly which tables they need.
Power BI apps that work across companies
Microsoft's nine Power BI apps for Business Central have been rebuilt to run on Fabric, in two versions:
- Single company, similar to the embedded apps you may already use.
- Multi-company, where one report shows data across several companies, with a filter to choose all of them or just the ones you care about.
If you run more than one Business Central company, that second version is the headline. Group-level finance and sales reporting without consolidating data by hand or stitching reports together. Microsoft says these apps are coming soon as code samples or on AppSource.
Built for administrators too
Mirroring is not a black box. Business Central writes two logs for every synchronisation: an overview and a detailed log. Both are available in the client under Monitoring, with ready-made views for all activity, errors only, or runs that actually pushed data. The same logs are also written into Fabric, so you can monitor the integration from either side.
Everything in setup and monitoring is also exposed through six APIs, and there are dedicated permission sets for activating, administering and reading the configuration, so you control exactly who can switch it on.
Where Equerra fits in
Turning mirroring on takes minutes. Getting real value out of it takes a bit more thought. That is where we help:
- Readiness and scoping. Which tables and companies you actually need, what Fabric capacity suits your volumes, and what your licensing looks like.
- Pilot during the preview. A low-risk proof of value on a sandbox or a single company, so you are ready to move when the feature reaches general availability.
- Power BI apps and custom reporting. Deploying Microsoft's multi-company apps, extending them, and building the reports your board actually asks for.
- Extensions and ISV data. Making sure custom fields, extension tables and ISV solutions come across properly, using configuration packages where they exist.
- Governance and monitoring. Permission sets, workspace security, and a monitoring routine that catches sync errors before your month-end does.
Get started
Fabric mirroring removes the hardest part of Business Central analytics: getting the data out. If you have been putting off a reporting project because the plumbing looked too expensive, now is a good time to look again.
Book a Fabric readiness session with Equerra and we will walk through what mirroring could look like for your business.
