Live in Business Central, eight refreshes a day in Power BI, hourly from a lake, or mirroring. What real-time means for finance and how to get it.
You get real-time financial reporting from Business Central in one of four ways, and which one you need depends on what real-time means for the person asking. Inside Business Central itself, financial reports (the former account schedules) and analysis mode on list pages are live to the second. Power BI connected to Business Central refreshes on a schedule, up to eight times a day on a Pro licence and up to forty-eight on a Fabric capacity, which is hourly or better. A lakehouse fed by an incremental extraction can run every fifteen minutes to an hour. And Business Central mirroring into Microsoft Fabric, announced by Microsoft at FabCon Europe in October 2026 with public preview expected in a 29.1 update, will replicate the ledger into OneLake continuously, giving near real-time Power BI without a pipeline. For finance, the useful definition is usually not seconds but confidence: the numbers on the report are the numbers in the ledger as of a time stamp everyone can see. This post walks through the four routes and which questions each one answers.
Route one: live inside Business Central
Financial reports in Business Central, the row and column definitions that used to be called account schedules, read the general ledger directly and are as live as the posting. Analysis mode on ledger entry pages lets a finance user pivot and total live data without leaving the system. For the question what is the cash position right now, or what has posted to this account today, this is the answer, and no Power BI model will beat it. Its limits are presentation, history and anything outside the ledger: it will not show a trend over three years, a budget held in a spreadsheet, or sales from the e-commerce platform next to the ledger.
Route two: Power BI on a schedule
Power BI reads Business Central through its APIs in import mode; the connector does not support DirectQuery, so every report is as fresh as its last refresh. On a Pro licence that is up to eight refreshes a day, on a Fabric capacity up to forty-eight, so a finance report can be refreshed every half hour during the working day. Microsoft's own Power BI apps for Business Central use this route. For month end, management packs and daily sales, this is real-time enough, and it is where most businesses should start. Microsoft's Power BI apps for Business Central covers what they give you and the refresh job they depend on.
Route three: an incremental lake load
For a group, or for reporting that joins Business Central to other systems, the data goes into a Fabric lakehouse through an incremental extraction such as bc2adls or an API-based pipeline keyed on the last modified timestamp, and Power BI reads the lake through Direct Lake with no refresh step of its own. The pipeline can run every fifteen minutes for the ledger tables that matter and nightly for the rest, and the report shows the load time. This is also the route that gives you history that outlives the ERP and the ability to put alerts on the data through Activator. Business Central to Microsoft Fabric: when it is worth it sets out the test.
Route four: mirroring
Business Central mirroring into Fabric will replicate Business Central tables into OneLake continuously, in the same way Azure SQL and Snowflake mirroring already do, which removes the extraction pipeline and makes route three near real-time by default. Microsoft announced it in October 2026 and expects a public preview in a 29.1 update, so it is a plan rather than a product today. A lakehouse built now on route three is designed so that mirroring replaces the extraction step and nothing else changes. Business Central to Fabric in zero ETL steps explains what the preview will mean.
What finance actually needs
In our experience the request for real-time reporting is usually a request for three other things: a report that matches the ledger, a visible time stamp so nobody has to ask whether it has refreshed, and an alert when something crosses a line (a customer over their credit limit, cash below a threshold, a margin outside its band). Route two with a load time on the report and a few Activator or Power BI alerts answers most of it. True intraday reporting, where an operations manager watches orders post, is route three on a frequent schedule or, soon, route four. The mistake is to build route three for a finance team that closes monthly and reads the pack weekly, which costs capacity for no benefit. What a reliable data pipeline looks like covers the time stamp and alerting side.
Where to start
Use Business Central's own financial reports for the live ledger questions, put the management pack on Power BI with a refresh every hour or two and a load time on the page, add alerts for the three or four numbers that need watching, and move to a lakehouse when a second company or a second system arrives or when the finance team asks for trend the ERP no longer holds. Our Business Central analytics page describes how we scope each step, and the free audit will tell you which route your reporting actually needs.
Related reading
Business Central to Fabric in zero ETL steps: what the new mirroring preview means
Business Central to Power BI: the complete guide to reporting beyond the built-in tools
The Business Central reports a finance team needs
Kiran Sahiba
Analytics Solutions Consultant
Part of the Hopton Analytics team, delivering governed analytics programmes for UK mid-market organisations.



