+1 480 485 7373
Microsoft Teams
Three levels of Power BI reporting
Microsoft's prebuilt reports
Installed from Microsoft and pointed at your environment and company, covering common finance, sales, purchasing and inventory questions.
- ✓Fastest way to see your own numbers
- ✓Built on Microsoft's data model
- ✓Test them against the reports you already rely on
Extended model
Microsoft's reports or model as a base, with your dimensions, custom fields and measures added through the connector and extra API pages.
- ✓Keeps familiar layouts
- ✓Needs a named owner for the model
- ✓Custom fields may need an API page first
Custom model or data warehouse
A purpose-built model, sometimes fed through a data lake or warehouse, for many companies, other systems or long history.
- ✓Combines ERP with CRM, payroll or ecommerce data
- ✓Handles consolidation and large volumes
- ✓The most design and upkeep of the three
Getting data out: connection methods compared
Why Power BI totals sometimes disagree with Business Central
The fastest way to lose a CFO's trust is a dashboard revenue number that does not match the trial balance. In a Business Central Power BI integration, the gap almost always comes from the model, not the connector. Common causes are mixed posting and document dates, or entries from one company but not another. Others are unposted documents counted as sales, or a dimension filter that quietly drops blank values.
We build every finance model to reconcile to Business Central before anything else. G/L totals by account and period must tie to the trial balance. Customer and vendor balances must tie to the aged receivables and payables reports. And inventory value must tie to the inventory valuation report. Only then do we design the visuals.
Refresh timing matters too. Power BI shows data as of its last refresh, so a report refreshed overnight will not show this morning's postings. Say so on the report page, and be clear about what the report is for. It shows trends and analysis; it does not replace looking up a live balance in Business Central.
Rolling out reports people keep using
- 1
List the questions, not the charts
Start with the decisions each role makes weekly, then choose the few measures that answer them.
- 2
Install and test Microsoft's apps
See how much the prebuilt reports already cover before building anything new.
- 3
Expose what is missing
Add API pages or queries for custom fields and tables, keeping each one narrow and filtered.
- 4
Reconcile, then design
Tie totals to Business Central reports first, then build pages with consistent colors and written definitions.
- 5
Embed where people work
Show key reports on role centers so users see them as soon as they sign in to Business Central.
When Power BI is the wrong tool
- ✓Someone needs a live, to-the-minute balance, which the Business Central page already shows
- ✓The request is a printable document such as a statement, which belongs in a report layout
- ✓A one-off question that analysis mode on a Business Central list answers directly
- ✓The problem is data quality in the ERP, such as postings missing dimensions
- ✓Only one person would view the report and an Excel export meets the need
- ✓Users need to edit records, which Power BI does not do
Power BI and Business Central questions
Does everyone need a Power BI licence?
Anyone viewing shared Power BI content generally needs a suitable Power BI licence or access through capacity your organization pays for. The rules and prices change, so check Microsoft's Power BI pricing page or ask your licensing partner. We design around the licences you already hold and say when a change would make sense.
Can Power BI combine several Business Central companies?
Yes, the connector can read each company, and the model can append them for group reporting. Intercompany eliminations and currency translation need explicit logic in the model, or can come from a consolidation company in Business Central. We decide which approach fits during design, based on how you close the books today.
Will scheduled refreshes slow Business Central down?
They can if a model pulls large tables in full at busy times. API queries, incremental refresh and off-peak schedules keep the load low. Business Central also applies its own limits to API requests, and a well-built model stays comfortably within them.
More Business Central Power BI integration questions
Can we see Power BI reports inside Business Central?
Yes, role centers and some list pages include Power BI parts where a user can choose reports to display. The user also needs access to that report in Power BI. It is a practical way to put a handful of key measures in front of people without asking them to open another app.
Should we use Microsoft Fabric or a data warehouse?
Only when volumes, history or the number of source systems make a direct connection to Business Central impractical. For many mid-sized companies the connector and a well-built model are enough. When a warehouse does make sense, we scope it as its own piece of work with its own written plan.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.