+1 480 485 7373
Microsoft Teams
Dynamics 365 Power BI reporting your finance team will trust
Dynamics 365 Power BI reporting should make the numbers match the ledger before making them look good. Many reporting projects produce attractive dashboards that nobody believes, because the totals do not tie to Business Central or Dynamics 365. We start from Microsoft's own connectors and Power BI apps, build the data model, reconcile it to the ledger, and only then design the reports: cash, margin, aging, stock and sales.
A Power BI consultant reconciles first, visualizes second
A report that disagrees with the trial balance by a few thousand dollars does more damage than no report, because it teaches people to go back to their spreadsheets. The cause is almost always the data model: dimensions joined the wrong way, postings counted twice, dates taken from the wrong field.
We build a model on the ERP data that ties to the general ledger to the cent, document every measure, and then design pages around the decisions each person makes. Finance gets the numbers it can defend, and sales and operations get the same numbers cut their way.
Power BI reports we build most often for Dynamics 365
Cash and working capital
Cash position, receivables and payables aging, and a rolling forecast from open orders and due dates.
Margin
Gross margin by customer, item, salesperson and region, with the costing method explained on the page.
Stock
Stock value, turns, slow movers and stock-outs by location, fed from item ledger entries.
Sales performance
Orders, invoiced sales and pipeline against budget, with drill-through to the document.
Management pack
A monthly board pack with profit and loss, balance sheet and key ratios, refreshed automatically.
Operations
Production output, on-time delivery and service levels for teams running manufacturing or field service.
Purchasing
Spend by vendor and category, open purchase orders and supplier delivery performance against promised dates.
Project profitability
Budget, actual cost, billed and unbilled amounts per project, for firms that bill by the job.
How a Power BI consultant runs a Dynamics 365 reporting project
- 1
Decisions list
We ask each report owner which decisions the report should support, and which numbers they check today.
- 2
Model and reconcile Dynamics 365 data in Power BI
We build the data model and reconcile it to the ledger and sub-ledgers, then explain and fix any differences.
- 3
Design pages
Owners review page layouts before we polish them, so nothing gets built twice.
- 4
Publish and secure
Workspaces, refresh schedules and row-level security, so people see only their region or entity.
- 5
Hand over from your Power BI consultant
A measure dictionary and a short training so your team can extend the reports without us.
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.
Power BI Finance app for Business Central or a custom model?
Why finance stops trusting a Power BI dashboard
- ✓The totals do not match the trial balance, and nobody can explain the difference.
- ✓Refresh fails quietly and the report shows last week's numbers with no warning.
- ✓Someone flips signs inconsistently, so revenue shows negative on one page and positive on another.
- ✓Business Central dimension values got new names, but the report still groups by the old ones.
- ✓Too many pages, so the one number the owner wants is three clicks away.
- ✓Nobody owns the report, so questions about a number go unanswered and people rebuild it in Excel.
Power BI row-level security for Business Central data
Permissions do not travel
A published dataset reads Business Central as the account that set up refresh. Anyone who can open the report sees whatever that account could read, regardless of their own Business Central permissions. Treat this as the key security step in any Power BI rollout on Business Central.
Define roles in the model
If different viewers should see different data, such as each regional manager seeing only their region, create row-level security roles in Power BI and assign people or groups to them.
Filter on a dimension
Row-level security usually filters on a dimension value, a salesperson code or a company. Make sure staff reliably fill in that field in Business Central, or the filter will hide real entries.
Test as each role
Use the view as role feature in Power BI Desktop and the service to confirm each group sees exactly what it should before you share the report widely.
Where our Power BI practice takes over
This page covers reporting that starts from Dynamics 365 and Business Central data: getting the connection right, tying totals to the ledger, and choosing between Microsoft's Power BI apps and a model of your own. When the work is mostly dashboard design, a company-wide Power BI rollout, or data from many systems beyond Dynamics 365, our sister site powerbiagency.com covers that Power BI work in depth. Both sites are run by Sataware.
Questions about Dynamics 365 Power BI reporting
Does Business Central come with Power BI reports?
Yes, Microsoft ships a set of standard Power BI reports for Business Central. They are a good start, but most companies need them adapted to their own dimensions, costing and management structure. We usually begin from those reports and add your own measures and hierarchies, so each figure matches what finance already reports.
Which licenses do we need?
People who build or share reports need Power BI Pro or Premium Per User, or a workspace in a capacity. People who only view reports need a license that matches how you share them: a Pro license, or free viewing of content hosted in a large enough capacity. We size this during scoping so nobody pays for the wrong tier.
Can Power BI combine ERP data with other systems?
Yes. We regularly combine Business Central with CRM, ecommerce and spreadsheet budgets in one model, with each source documented. Each source gets a scheduled refresh and a named owner, so when a number looks wrong, someone knows where it came from and who can fix it.
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.