Business CentralROI & Value

How much does Business Central analytics and reporting cost? Licences, tools and the build, by route

SD

Simon Devine

Managing Director

November 2026·6 min read
Pile of pound coins

Free apps and a Pro licence, a custom model in weeks, or Fabric from £138 a month plus the build. What Business Central analytics costs on each route.

Business Central analytics and reporting costs depend on which of three routes you take. Microsoft's Power BI apps for Business Central are free, so a single company's finance and sales reporting costs the Power BI Pro licences at £10.80 per user per month and a day or two of setup. A Power BI semantic model of your own, built to your definitions over the Business Central APIs, is a project measured in weeks rather than months plus the same licences, with Jet Analytics or Cosmos as a subscription alternative that provides the model for you. A Microsoft Fabric platform that holds Business Central alongside other systems adds a capacity from £138 a month reserved for an F2 and a build of ten to sixteen weeks after a four-week Establish phase. Those are the October 2026 UK list prices excluding VAT, and the rest of this post explains what sits behind each number, what drives the build cost, and how to avoid paying for a route you do not need.

Route one: Microsoft's apps and a Pro licence

The nine Power BI apps for Business Central, with 116 reports between them, are free from the marketplace. Every person who installs, refreshes or views them needs a Power BI Pro licence at £10.80 per user per month (or Premium Per User at £18.50) and a paid Business Central licence. A twenty-person finance and sales team is therefore £216 a month in Power BI licences, and the setup is running the Connect to Power BI wizard and the dimension job. If you run one company, accept Microsoft's definitions of margin and ageing, and your questions are the standard ones, this is the whole cost. Our post on the apps sets out where they stop.

Route two: a model of your own

When definitions differ from Microsoft's, when there is more than one company, or when budgets and history outside the ERP need to sit beside the ledger, you need a semantic model built to your business. The licences are the same Pro licences. The build is the cost: a short Establish phase to agree definitions, then the extraction, model and core reports, which for a single company with finance, sales and stock reporting is a few weeks of work and for a multi-company group with its own chart of accounts mapping is longer. We price this as fixed phases rather than a day rate, and our post on fixed pricing explains why. Jet Analytics and Cosmos are the alternative: a subscription per user or per company, quoted by the vendor, that gives a pre-built model and finance-friendly reporting over the standard tables, with a smaller implementation. Power BI for Business Central: extraction patterns, timelines and the Jet vs Cosmos decision covers that choice.

Route three: a Fabric platform

For a group, for a business with a CRM, warehouse or e-commerce system to report with the ledger, or for anyone who wants history that outlives the ERP, Business Central data goes into a Fabric lakehouse. The capacity costs from £138 a month reserved for an F2, with most Business Central estates sitting on an F4 to F16, between £275 and £1,101 a month reserved; viewers still need Pro licences below F64. The build is the larger part: a four-week Establish phase and ten to sixteen weeks of delivery covering extraction, lakehouse, semantic model and reports, with other systems conformed to Business Central as they arrive. How much does Microsoft Fabric cost? has the full capacity price list and Business Central to Microsoft Fabric: when it is worth it sets out when the route is justified.

What drives the build cost

Four things. The number of companies, because consolidation needs account and dimension mapping that a single company does not. The distance between your definitions and Microsoft's, because every custom measure is agreed, built and reconciled. The number of other systems, because each one is an extraction, a conforming step and a set of matched keys. And the state of the data, because dimensions used inconsistently or master data duplicated across companies has to be cleaned before it can be reported. Report count matters less than people expect once the model exists; a new report over a good model is a day.

The costs that are not on any price list

The dimension job not running, so the apps show nothing and a month is lost. A model built before finance agreed what margin means, so it is rebuilt. Pro licences bought for viewers who never open a report. And the cost of not doing it: the finance team's hours each month end exporting to Excel, which is usually the largest number in the whole calculation and the one nobody has written down. The Business Central reports a finance team needs is a good starting point for working out what that time is worth.

Where to start

If you have one company and no Power BI reporting, install the apps, buy the Pro licences and run the dimension job; the cost is under £300 a month for most teams. If your finance team is exporting to Excel, the next step is a model of your own, and the question is definitions rather than tooling. If a second company or a second system is on the horizon, plan the Fabric route from the start so the model is built once. Our Business Central analytics page describes how we scope each, and the free audit will give you a cost for your own estate before you commit.

Related reading

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

Microsoft's Power BI apps for Business Central: what you get, what you don't, and when to go beyond them

How much does Microsoft Fabric cost? UK prices for 2026

Fixed price, not time and materials: how we scope and price analytics work

SD

Simon Devine

Managing Director

Part of the Hopton Analytics team, delivering governed analytics programmes for UK mid-market organisations.

FAQs

Frequently asked questions

Get started

Ready to put this into practice?

Reading about better analytics is a start. Working with us is how it happens.

Book a free Data Assessment