Business Central to Power BI: the complete guide to reporting beyond the built-in tools

If your finance team still exports Business Central to Excel every month, the problem is not the team - it is that Business Central's built-in reports were never designed for cross-functional management reporting. Here is every option for doing it properly with Power BI.

If your finance team still exports Business Central to Excel every month, the instinct is to blame the process, or the team, or the discipline. It is none of those. Business Central is excellent at running transactions, but its built-in reports were designed for operational lists - a stock report, an aged debtors list - not for the cross-functional management reporting a business actually runs on. Ask it to trend performance over several periods, consolidate across multiple companies, or combine finance data with CRM and payroll, and it strains. So people export to Excel, and the monthly ritual begins. This guide covers every sensible way to do it properly with Power BI, and how to choose between them.

Why the built-in reports run out of road

Business Central's native reporting is fine for what it was built for. The trouble starts at the edges of management reporting: multi-period trend analysis, consolidated numbers across several BC companies, and - most of all - bringing Business Central together with data that lives elsewhere. A real management pack needs sales pipeline from the CRM, headcount from payroll, project data from the delivery system, all lined up against the finance numbers. Business Central cannot see any of that on its own, so the export-to-Excel workaround fills the gap, and with it come version control problems, no single source of truth, and a number that is out of date the moment it lands in the spreadsheet.

The options, from simplest to most capable

There is no single right answer - the right approach depends on your data volume, how many systems you need to combine, and how much self-service your finance and operations teams want.

Direct connection via the OData API. For smaller volumes and a single company, Power BI can read Business Central directly through its OData API. It is the quickest route to live dashboards and the lowest overhead. It starts to creak when data volumes grow, when you need several sources combined, or when refresh performance matters - OData was not built to move large amounts of data quickly.

A dedicated data layer via Microsoft Fabric and OneLake. When you have larger volumes, several data sources to combine, multiple BC entities to consolidate, or you want finance-team self-service that does not fall over, the right pattern is to land Business Central data into a proper data layer - Microsoft Fabric with OneLake - clean and model it there, and report on it from Power BI. This is more to set up, but it is what gives you genuinely reliable, governed reporting and a single source of truth that scales.

Multi-entity consolidation. Groups running several Business Central companies hit a specific wall: the native tools do not consolidate cleanly across entities. Building a consolidated P&L across multiple BC companies is a modelling job done properly in Power BI, usually over a Fabric layer, and it is one of the highest-value things a group can build - one board pack, every entity, reconciling.

What it costs and when to move

The honest signal that you have outgrown the built-in tools is simple: if your finance team spends the first days of every month rebuilding the same reports in Excel, the cost of doing nothing is already higher than the cost of fixing it - it is just hidden in people's time. A direct-connection Power BI build is a modest, quick engagement. A full Fabric-backed platform for a multi-entity group is a larger programme, but it is the one that removes the manual monthly work permanently rather than moving it around.

The decision is rarely about the technology and almost always about scale: one company and a handful of dashboards can start directly in Power BI; several systems, several entities, or a finance team that needs to self-serve points to Fabric.

Where to start

Start with the single report that hurts most - usually the consolidated management P&L - and get it live, governed, and reconciling. That proves the foundation and pays for itself in reclaimed month-end time, and everything else has something solid to build on.

Hopton Analytics builds Power BI and Fabric reporting on top of Business Central for mid-market businesses, from a first direct-connection dashboard to a full multi-entity platform.

Related reading: Business Central analytics and reporting and cloud data platform and warehouse build.