+1 480 485 7373
Microsoft Teams
First Power BI connection to Business Central, step by step
- 1
Confirm licences and access
The person building reports needs a Business Central user with permission to read the data involved and a Power BI licence that allows publishing. Sharing reports with colleagues generally needs Power BI Pro or Premium Per User licences, or a capacity, so check Microsoft's current terms.
- 2
Open the connector in Power BI Desktop
Choose Get Data, search for Dynamics 365 Business Central, and sign in with your organizational account. Use the online connector for Business Central online; on-premises installations connect differently and need a gateway for scheduled refresh.
- 3
Pick the environment
The navigator lists environments such as PRODUCTION and any sandboxes. Build and test against a sandbox copy so experiments never touch live data, then point the finished report at production.
- 4
Pick the company
Under each environment you choose a company, then the API endpoints or published web services beneath it. Each query reads one company, which matters later if you report across several.
- 5
Select only what you need
Load the tables your report uses and filter early, for example by posting date. Pulling every general ledger entry for every year makes refresh slow for no benefit.
Starting with Microsoft's Power BI apps for Business Central
Before building anything, try the reports Microsoft already provides. There are Power BI apps and reports for Business Central covering areas such as finance, sales, purchasing and inventory, and recent versions also show Power BI reports directly inside Business Central. You install them from Microsoft, then connect them to your environment and company.
Give them a fair trial with a controller present. Compare a few totals, such as revenue for a closed month and inventory value at a period end, against the figures in Business Central. If they match and answer most of the questions people ask, you may not need a custom report for months. That check is the cheapest step in any Power BI with Business Central setup guide.
Where they fall short, the gap is usually one of three things: a dimension or custom field that is not in the standard model, a combination of companies, or a management layout the business knows. Those gaps are what justify an extended or custom model, and our Business Central Power BI integration page explains those options.
Environments and companies: getting the target right
Refresh: keeping Power BI reports on Business Central current
Once you publish a report to the Power BI service, the semantic model behind it needs credentials and a refresh schedule. For Business Central online the data source is in the cloud, so you need no gateway. You sign in on the dataset settings page and set the schedule. How often refresh can run depends on your Power BI licence, so check the current limits for your plan.
Refresh failures usually come from three causes. The account whose credentials the dataset uses has left, lost its Business Central permissions or changed its password. Someone renamed a company or environment. Or the volume grew until the refresh times out. Use a dedicated, well-documented account for important reports, and add incremental refresh or date filters before volume becomes a problem.
Tell users when data was last refreshed. A small card on each page showing the refresh time saves a surprising number of arguments about why a figure differs from what someone saw in Business Central ten minutes ago.
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 this Power BI with Business Central setup guide.
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.
Power BI with Business Central setup questions
Why do Power BI totals not match Business Central?
Usually the report is filtering or combining data differently from the Business Central page you are comparing with. Common causes are posting date versus document date, one company loaded but not another, or a dimension filter excluding blank values. Stale data from an old refresh is another. Check the refresh time first, then compare a single month account by account.
Do we need a gateway for Business Central online?
No, Business Central online is a cloud data source, so scheduled refresh runs without an on-premises data gateway. You need a gateway if you connect to Business Central on-premises, or if the same report also reads files or databases on your own network. In that case the gateway machine must be running at refresh times.
Can Power BI reports appear inside Business Central?
Yes. Business Central can show Power BI reports on role centers and in report parts on certain pages, and recent versions include embedded Power BI reports from Microsoft. Viewers still need an appropriate Power BI licence to see content. Security inside those reports follows Power BI's rules, not Business Central's.
Power BI with Business Central setup guide: APIs and ownership
Should we use APIs or published web services?
Use the standard APIs where they contain what you need, since Microsoft designed them for integration and tend to perform better. Published web services from pages or queries fill gaps, such as a custom field or a page with no API equivalent. For larger or more specific needs, a custom API query in an extension gives precise, efficient data.
Who should own the reports after setup?
One named person in finance or operations should own each important report, with a documented refresh account and a sandbox copy for changes. Without an owner, broken refreshes go unnoticed and reports drift from the numbers. If nobody internally has the time, include report upkeep in your support arrangement.
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.