Business Central Power BI: Setup, Reports and Dashboards

Business Central Power BI integration lets you analyze Microsoft Dynamics 365 Business Central data in Power BI and show those reports inside Business Central. You can install Microsoft’s ready-made Power BI apps for finance, sales, purchasing, inventory, projects and manufacturing, or build your own reports in Power BI Desktop using the Business Central connector.

Introduction

Most Business Central users I talk to have the same complaint about reporting. The data is all there, but getting a clear answer out of it takes too long. Someone exports to Excel, someone else fixes the formulas, and by the time the month-end pack is ready, the numbers are already a week old.

Power BI fixes a lot of that. It reads data straight from Business Central, turns it into dashboards people can filter and click through, and refreshes on a schedule so nobody has to rebuild the same spreadsheet every Monday.

In my experience, the hard part isn’t Power BI itself. It’s knowing which of the several ways to connect fits your business, which reports to start with, and what licenses you actually need. That’s what this guide covers. If you’re also looking at wider Microsoft Dynamics 365 Business Central services such as setup, customization or report building, I’ll point out where outside help makes sense along the way.

What Is Business Central Power BI Integration?

Business Central Power BI integration is the connection that lets Power BI read data from Dynamics 365 Business Central and lets Business Central display Power BI reports on its own pages. Data flows from Business Central into a Power BI semantic model, and reports built on that model can be viewed in the Power BI service or embedded back inside Business Central.

There are two directions to keep in mind:

Business Central to Power BI. Power BI pulls data through the Business Central connector. The connector reads API pages, queries and pages published as web services.
Power BI back into Business Central. Finished reports can be embedded on Business Central pages, such as role centers and FactBoxes, so users see charts without leaving the ERP.

That second part is what makes the setup feel like one system. A sales manager can open their role center in Business Central and see the sales dashboard right there.

Why API pages matter for reporting

Power BI can read Business Central data through API pages or older web services. Microsoft recommends API pages, and its own tests found them up to 25% faster than web services for Power BI.

When a standard API page doesn’t expose a field you need, a developer can build one. I’ve seen teams lose weeks trying to work around missing fields in reports, when a small custom Business Central API would have solved it in a day. The same choice comes up in other integration work too, and the trade-offs of API vs connector for Business Central integration apply to reporting just as much as to ecommerce.

Is it real-time business intelligence?

Not quite, and it’s worth being honest about this. Power BI reports built on imported data show what Business Central held at the last refresh. You set the refresh schedule in the Power BI service.

For most finance and operations reporting, a refresh every few hours or overnight is enough. Microsoft also notes that reports created after February 2022 read from a read-only copy of the Business Central database, so refreshes don’t slow down people posting transactions.

If you’re looking for real-time business intelligence in your ERP for something like live order counts, you’ll usually combine Power BI with Business Central’s own lists and role center cues, which always show current data.

What Power BI Apps Does Microsoft Provide for Business Central?

Microsoft provides ready-made Power BI apps for the main areas of Business Central, so you don’t have to build every report from scratch. Since the 2024 release wave 2, many of these reports are also available embedded inside Business Central. Microsoft’s release notes on out-of-the-box Power BI reports in Business Central list general availability on November 15, 2024.

The current list of Power BI apps for each functional area includes:

Power BI app	Example reports
Finance	Financial Overview, Income Statement, Balance Sheet, Budget Comparison, Liquidity KPIs, EBITDA, Aged Receivables, Aged Payables
Sales	Sales Overview, Daily Sales, Sales by Customer, Sales by Salesperson, Sales Forecasting, Customer Retention Overview
Purchasing	Purchases Overview, Purchases by Vendor, Actual vs Budget, Purchase Forecasting, Vendor Quality Analysis
Inventory	Inventory Overview, Inventory by Item, Inventory by Location, Item Availability, Bin Contents
Inventory Valuation	Inventory Valuation Overview, by Item, by Location
Projects	Project Overview, Project Profitability, Project Realization, Project Timeline
Manufacturing	Current Utilization, Work Center Load, Consumption Variance, Production Scrap, Production Order WIP
Sustainability	CO2e Analysis, Emissions by Category and Scope, Sustainability Overview
Subscription Billing	Subscription Billing Overview, Revenue Analysis, Churn Analysis

For many businesses, these apps cover most of what management asks for in the first few months. That’s why I always start here before building anything custom.

How to Connect Power BI to Business Central

There are two main ways to connect Power BI to Business Central: install Microsoft’s template apps, or build your own reports in Power BI Desktop with the Business Central connector. Most companies end up using both.

Option 1: Install the Business Central Power BI apps

This is the fastest route to working reports. Microsoft’s steps to install the Power BI apps for Business Central come down to this:

Check prerequisites. You need Business Central online and permission in Power BI to install template apps and use shared workspaces.
Confirm the connector app. The Business Central side of the connector comes preinstalled.
Install the template app. Open the install link for the functional area, such as Sales or Finance, choose Get it now, and sign in. Choose OAuth2 for authentication and set the privacy level to Organizational.
Pick a workspace. Microsoft suggests one workspace per app, which makes access control easier.
Run the Connect to Power BI assisted setup in Business Central. It asks for calendar type, UTC offset, date table range, work days and report mapping.
Set the Environment and Company parameters on the semantic model in the Power BI service. The company name is case sensitive.
Refresh the data, manually or on a schedule.
Run the “Update Dim. Set Entries” job queue entry so dimension data shows up in reports. Run it again whenever dimensions change.

Two details catch people out. First, each company needs its own template app setup. Second, the apps are English only.

Option 2: Build custom reports in Power BI Desktop

When the template apps don’t answer a question, build your own:

Open Power BI Desktop, which is free.
Choose Get data and select the Dynamics 365 Business Central connector.
Sign in with your Business Central account.
Pick the environment and company.
Select the API endpoints or queries you need, such as customers, items, sales invoices or general ledger entries.
Clean and shape the data in Power Query, filtering as early as you can.
Build your visuals, then publish to the Power BI service.
Set a scheduled refresh and, if you want, embed the report on a Business Central page.

A tip from experience: filter in Power Query, not in the visuals. Microsoft notes that most Power Query filters are pushed back to Business Central, so less data travels and refreshes run faster.

What about third-party connectors?

Microsoft’s own Business Central Power BI connector covers most needs. Third-party connectors and ODBC drivers exist for special cases, such as very large data volumes or combining many sources. Before paying for one, check whether a custom API page plus the standard connector would do the job. In my experience it usually does.

What Licenses Do You Need for Business Central Power BI?

You need a Power BI license on top of Business Central. The level depends on whether you share reports.

According to Microsoft’s Power BI licensing answers for Business Central:

Power BI free license. Lets you build and publish reports for yourself. You can’t share them or install the Business Central apps for Power BI.
Power BI Pro. Needed to share reports. For the template apps, the person who installs the app, the person who refreshes the data and every person who views the reports needs Pro, whether they view in Power BI or inside Business Central.
Power BI Premium or Microsoft Fabric capacity. An alternative to giving every viewer a Pro license, usually for larger organizations.

My advice: list who will view reports before buying licenses. A small finance team may only need a handful of Pro licenses, while a company that wants dashboards for every warehouse lead should compare Pro with capacity pricing.

Best Power BI Reports for Business Central

The best Power BI reports for Business Central are the ones people open every week without being reminded. Here are the ones I’d set up first.

Business Central financial reports

Start with finance, because that’s where Excel pain is usually worst.

Income Statement and Balance Sheet. Month-by-month comparisons that finance teams otherwise rebuild in Excel.
Budget Comparison. Actuals against budget by account and dimension.
Aged Receivables and Aged Payables. Balances grouped into aging buckets, with drill-down to customers and vendors.
Liquidity KPIs and EBITDA. A quick health check for owners and directors.

These Business Central financial reports come ready in the Finance app, which makes them the quickest win.

Sales and customer reports

Sales by Customer and by Salesperson for commission and account reviews.
Daily Sales and Moving Average to spot trends early.
Customer Retention Overview to see who stopped ordering.

Inventory and purchasing reports

Item Availability and Inventory by Location for stock planning.
Purchases by Vendor and Vendor Quality Analysis for supplier reviews.
Inventory Valuation reports for month-end.

Custom reports worth building

Some questions need a custom report. The ones I see most often:

Ecommerce channel performance. Sales split by web store, marketplace and B2B, using data synced from your online store.
Margin by item and customer. Including landed costs and discounts.
Cash flow forecast. Combining open receivables, payables and planned purchases.

How to Design a Power BI Dashboard for Business Central

A good Power BI dashboard for Business Central answers one person’s daily questions on one screen. When I design one, I follow a few rules:

Pick one audience. A CFO dashboard and a warehouse dashboard should never be the same page.
Lead with five or six numbers. Revenue, margin, cash, overdue receivables, stock value, open orders. Details go one click deeper.
Use the same filters everywhere. Date, company and dimension filters should work the same on every page.
Match Business Central terms. Use the account names and dimension values people already know.
Embed it where people work. Put the dashboard on the Business Central role center so users don’t have to open another app.
Show the refresh time. Add a “last refreshed” card so nobody mistakes yesterday’s numbers for live data.

Understanding the Power BI Semantic Model

A Power BI semantic model is the layer that holds the tables, relationships, measures and calculations that reports are built on. It used to be called a dataset. When you install one of Microsoft’s Power BI apps for Business Central, it creates a semantic model in your workspace, and the app’s reports sit on top of it.

Why this matters:

One source of truth. Several reports can share the same semantic model, so “revenue” means the same thing everywhere.
Refresh happens here. You schedule the refresh on the semantic model, not on each report.
Parameters live here. The Environment and Company settings for the Business Central apps are set on the semantic model.

If you build custom reports, spend time on the model first: clean tables, clear relationships and well-named measures. Good models make good reports easy. Messy models make every new report a fight.

A Practical Example: Month-End Reporting Before and After

Here is a scenario I see often, described in general terms rather than as a specific client.

A distribution company runs Business Central with two legal entities and a WooCommerce store. Before Power BI, the finance lead exports trial balances from both companies at month-end, pastes them into a master Excel file, adds sales data from a separate export, and fixes broken lookups. The pack takes days, and the sales team only sees it once a month.

After setting up Power BI, the flow looks different:

The Finance app delivers the Income Statement, Balance Sheet and aging reports for each company.
A custom report built in Power BI Desktop combines both companies’ general ledger entries through the Business Central connector, so the group view no longer needs copy and paste.
A sales dashboard shows web store and B2B sales side by side, using the orders already synced into Business Central.
Scheduled refreshes run overnight, and the key dashboards sit on the Business Central role centers.

The month-end pack turns into a review meeting instead of a building exercise, and the sales team checks the same numbers weekly instead of monthly. Nothing about this needs exotic tools. It’s the standard connector, the template apps and a few well-planned custom reports.

Business Central Reporting: Power BI vs Built-In Reports vs Excel

Business Central reporting isn’t only Power BI. Each tool has a job.

Tool	Best for	Limits
Built-in Business Central reports	Printable documents, statutory reports, account schedules	Less interactive
Excel (Edit in Excel, analysis mode)	Quick ad hoc analysis by finance users	Hard to share and keep consistent
Power BI	Interactive dashboards, trends, cross-company views, sharing	Needs licenses and a refresh schedule

I usually tell clients: keep invoices and statutory reports in Business Central, keep quick one-off checks in Excel or analysis mode, and move anything that gets rebuilt every week into Power BI.

Security and Access for Power BI Reports in Business Central

Reporting opens up data to more people, so it’s worth planning access before you share anything.

A few points to get right:

Business Central permissions still apply to the connection. The account used to connect needs permission to read the tables, API pages or web services the report uses.
Workspaces control who sees what in Power BI. This is one reason Microsoft suggests a separate workspace per Power BI app.
Shared reports need the right licenses. People who view shared Power BI reports in Business Central need Pro licenses or content in a Premium or Fabric capacity.
Row-level security is a Power BI feature you can add to custom semantic models, for example so each sales manager sees only their own region.

In my experience, the safest setup is boring: a short list of workspaces, named owners for each one, and a clear rule on who can publish. It saves a lot of awkward conversations when someone sees salary or margin data they shouldn’t.

Common Mistakes to Avoid

These are the problems I see most often with Business Central Power BI projects:

Using old web services instead of API pages. They’re slower and Microsoft doesn’t recommend them for Power BI.
Pulling every table. Load only what reports need, and filter in Power Query.
Wrong company name. The Company parameter must match exactly, including capital letters.
Forgetting the dimension job. Without the “Update Dim. Set Entries” job queue entry, dimension filters show blanks.
Refreshing during work hours. Schedule big refreshes outside business hours.
Licensing surprises. Viewers of shared reports need Pro or capacity licenses. Plan this before rollout.
No owner. Someone needs to check failed refreshes and keep measures accurate.

Tips to Get More From Power BI in Business Central

Start with the template apps, then build custom reports only for gaps.
Use one workspace per app to keep permissions simple.
Create a small set of shared measures for revenue, margin and cost, and reuse them.
Document every custom report: data source, refresh time and owner.
Plan for multiple companies early, because each company needs its own app setup.
Get ongoing help when needed. If reports break after an update or a new company is added, good Business Central support services will catch it before month-end does.

Microsoft also describes how Power BI fits with Power Automate and Power Apps in its overview of integrating Business Central with Microsoft Power Platform, which is useful if you plan to automate alerts based on report data.

Key Takeaways

Power BI Business Central integration reads data through the Business Central connector and can embed reports back inside Business Central.
Microsoft provides ready-made Power BI apps for finance, sales, purchasing, inventory, inventory valuation, projects, manufacturing, sustainability and subscription billing.
Use API pages rather than web services. Microsoft found them up to 25% faster for Power BI.
Reports are refresh-based, not truly real-time. Schedule refreshes outside working hours.
A free Power BI license works for personal reports. Sharing and the template apps need Pro or capacity licensing.
Start with the financial reports, then build custom dashboards for gaps.

Frequently Asked Questions

What is Business Central Power BI?

Business Central Power BI is the integration between Microsoft Dynamics 365 Business Central and Microsoft Power BI. It lets you analyze Business Central data in interactive Power BI reports and dashboards, and embed those reports on Business Central pages so users see insights without leaving the ERP.

Does Business Central include Power BI?

Business Central includes the connector and can display embedded Power BI reports, but Power BI itself is licensed separately. A free Power BI license lets you build personal reports. To share reports or use Microsoft’s Power BI apps for Business Central, users need Power BI Pro or a Premium or Fabric capacity.

How do I connect Power BI to Business Central?

You can install Microsoft’s Power BI template apps for Business Central, or open Power BI Desktop, choose Get data, and select the Dynamics 365 Business Central connector. After signing in, pick the environment, company and data you need, then build and publish your report.

Is Power BI free with Business Central?

Power BI Desktop is free, and the free Power BI license lets you create and publish reports for your own use. Sharing reports with colleagues, viewing embedded app reports and installing the Power BI apps for Business Central require Power BI Pro licenses or a Premium or Fabric capacity.

What are the best Power BI reports for Business Central?

Most companies get the fastest value from the Finance app reports: Income Statement, Balance Sheet, Budget Comparison, Aged Receivables and Aged Payables. After that, sales by customer, item availability and inventory valuation reports usually answer the next most common management questions.

Can Power BI show real-time Business Central data?

Power BI reports built on imported data show Business Central data as of the last refresh, so they aren’t truly real-time. Most teams refresh every few hours or overnight. For up-to-the-minute figures, Business Central’s own lists and role center cues always show current data.

Can I report on multiple Business Central companies in Power BI?

Yes. With custom reports, you can connect to several companies and environments and combine them in one model. With Microsoft’s template apps, each company needs its own app installation and setup, so plan for that if you run several legal entities.

What is a Power BI semantic model?

A Power BI semantic model is the layer that stores tables, relationships, measures and calculations for reports. It was formerly called a dataset. Several reports can share one semantic model, and refresh schedules and connection parameters, such as Business Central environment and company, are set on it.

Should I use API pages or web services for Power BI?

Use API pages where possible. Microsoft recommends them over web services for Power BI and reports that they performed up to 25% better in its tests. If a standard API page lacks a field you need, a developer can create a custom API page.

Do I need a developer to set up Power BI for Business Central?

Not always. Installing Microsoft’s template apps and building simple reports can be done by a confident finance or IT user. You’ll want a developer or partner for custom API pages, complex data models, multi-company reporting or embedding custom reports across Business Central pages.

Conclusion

Business Central Power BI turns the data you already have into reports people actually use. Start with Microsoft’s template apps, especially the finance reports, get your licenses right, and schedule refreshes outside working hours. Then build custom dashboards only where the standard reports fall short.

The setup is simple when the basics are right and frustrating when they aren’t: wrong company names, missing dimensions, slow web services and surprise license costs cause most of the trouble I see.

If you want Power BI dashboards built around your Business Central data, from financial reports to ecommerce sales analysis, talk to a Business Central Power BI team at New Wiz Tech about what your business needs to see.