Pre-Built Power BI Dashboards for Microsoft Dynamics 365 Business Central

Six ready-to-use dashboard packs putting your Sales, Finance, Inventory, AP, AR, and Purchasing KPIs in your Cosmos portal on day one. No SQL, no DAX, no setup project required.

Ready-to-use, multi-page Power BI dashboards that connect directly to your Business Central data through Cosmos.

Pre-built Power BI dashboards for Business Central give your team Finance, Sales, Inventory, AP, AR, and Purchasing analytics without building a single report from scratch. The dashboards are new, but they are powered by the proven Cosmos data models customers have relied on across these six areas since 2022. No SQL. No DAX. No coding. See how they extend your Business Central dashboards.

Built exclusively for Business Central
Included with the Cosmos Power BI add-on
Multi-page, fully customizable
Runs on governed Cosmos data

Explore the Interactive Dashboards Live

Screenshots flatter every dashboard. Instead, explore the real thing below: a live, interactive Power BI dashboard running on sample Business Central data. Click into a category, see what informs each visual, and switch between pages and packs. Everything you can do here, your team can do in your Cosmos portal. Each dashboard is multi-page, totally interactive, and complete with full drill-down capabilities. They are yours to explore.

Power BI Sales Dashboard: Profitability Down to the Item and the Rep

The Sales pack opens with sales, cost, and profit by item category, so the first screen answers the question most sales analysis starts with: where the margin actually comes from. From there, drill through to individual item detail or to salesperson scorecards that show how each rep is performing against the numbers that matter. It is multi-page and fully interactive. A VP of Sales and a controller can work from the same pack and each find their own view.

Power BI Finance Dashboard: From Net Income to the P&L Line Behind It

Revenue, gross profit, net income, and cash, all on one financial dashboard. The centerpiece is a P&L dashboard view: an at-a-glance summary with expandable lines and filters. When a number looks off, you open the line and see what sits underneath it instead of requesting a report and waiting. For a CFO or controller, it turns the monthly “walk me through this figure” conversation into a thirty-second drill through. Check out each page of the dashboard!

Power BI Inventory Dashboard: Value, Turns, and Days of Supply by Location

Inventory value on hand, turns, and days of supply, broken out across every location you run. The Inventory pack gives operations and finance the same picture of what is sitting on shelves, what is moving, and where supply is running long or short, without anyone exporting a single item ledger. Each pack is multi-page and fully interactive.

Power BI Accounts Payable Dashboard: What Is Due, When, and to Whom

Payables aging, upcoming due dates, and vendor balances in one place. The AP pack shows what needs to be paid this week, what can wait, and which vendor relationships carry the largest open balances, and cash decisions get made from current numbers rather than last Friday’s export. Explore the multi-page dashboards.

Power BI Accounts Receivable Dashboard: Aging, DSO, and Collections

AR aging, days sales outstanding, and collections status at a glance. The AR pack makes it obvious which invoices are aging past terms and where DSO is trending, so collections conversations start earlier and the month-end cash position holds fewer surprises. Check out each interactive page!

Power BI Purchasing Dashboard: POs, Spend, and Supplier Performance

Open purchase orders, spend by vendor and category, and supplier performance over time. Whether you call it purchasing or procurement, the questions are the same: who are we buying from, at what price, and are they delivering? This pack answers all three on one screen, with drill through to the PO detail behind any figure.

The Best Power BI Dashboard Templates Built Just for Business Central

Most Power BI dashboard templates are generic shells. You download one, then spend weeks mapping your ERP data into someone else’s field names and hoping the margins still reconcile. These six Power BI report packs skip that stage entirely. They run on the Cosmos data model for Microsoft Dynamics 365 Business Central, the same governed model Cosmos customers have reported against since 2022, and revenue, cost, and quantity land in the right place before you ever open a report.

Each report is a multi-page report rather than a single canvas of tiles. Summary views sit up front, and numbers have detail behind them that you can drill through to. And because these are true Business Central Power BI templates, your team can modify any of them: change a visual, add a page, or rework a layout without starting from a blank screen.

Executive KPI’s in Every Dashboard

Function-level packs serve the people who live in those functions. Executives need the cross-cut. Taken together, the six packs work as a Power BI KPI dashboard for the whole business: sales performance, margin, cash, payables, receivables, and supplier spend, each one drillable from the summary an executive reads to the transaction detail a manager owns. That is the difference between a Power BI executive dashboard and a slide with last month’s numbers on it: when someone asks a follow-up question in the meeting, you answer it in the meeting.

How These Compare to Microsoft’s Free Power BI Apps for Business Central

Microsoft publishes free Power BI apps for Business Central covering areas like finance, sales, and inventory, and they are a legitimate starting point. If you have never seen your Business Central data in Power BI, install one and look around.

Achieve More With Cosmos Pre-Built Power BI Dashboards

The differences show up as your requirements grow. The free apps report on one company at a time, so consolidated views across entities become your project to build and maintain. Customization works the same way: you can modify the apps, but you own the result, including rework when something changes upstream. The Cosmos packs report across companies from the start, and because they run on the governed Cosmos data model, modifications are supported rather than self-maintained. Technical support is included with every Cosmos subscription, so we can help you achieve the outcomes you’re looking for.

Available In Your Cosmos Portal on Day One

Simple downloads and no complex implementation phase to schedule. If your Cosmos subscription includes the Power BI feature, all six dashboard packs are available in your Cosmos portal out of the box, already running against your Business Central data through how Cosmos works with Power BI. Day one means day one: with one simple download, the dashboards are ready to go.

Why Pre-built

Analytics liftoff, without the build

Live in minutes, not months

Connect Business Central once and turn on the add-on. The six dashboards open with your data, day one, instead of the six-month build a BI project usually takes.

No SQL. No DAX. No coding.

Built for everyday users, not technical resources. Customize a visual, add a slicer, or extend a page in Power BI, with no model wrangling and no scripts to maintain.

Built on the Cosmos data engine

Every dashboard reads from a governed Cosmos warehouse, not raw Business Central APIs, so figures stay consistent across companies and the data is cleansed before it ever hits a visual.

How these compare to Microsoft’s built-in Power BI apps

Microsoft ships free Power BI apps for Business Central, one per functional area. They are a real starting point. Here is where the pre-built Cosmos dashboards take a different path.

Microsoft’s built-in Power BI apps Pre-built Cosmos dashboards
Multi-company view Microsoft’s built-in Power BI apps Per-company workspaces. Each company needs its own app install and workspace, with no consolidated cross-company view. Pre-built Cosmos dashboards Cross-company by design. Filter Sales, Finance, Inventory, AP, AR, and Purchasing across all your companies in one place.
Customization Microsoft’s built-in Power BI apps Design-only in the managed app (slicers, layout, swapping visuals). To change the model you fork the open-source .pbix and self-maintain it, leaving the managed update path. Pre-built Cosmos dashboards Fully customizable and supported. Extend pages, add measures, and keep the dashboards maintained as part of the add-on.
Data foundation Microsoft’s built-in Power BI apps Reads directly from raw Business Central APIs (ODataV4). Pre-built Cosmos dashboards Reads from a governed Cosmos warehouse, cleansed and multi-source, so figures are consistent before they reach a visual.
Setup Microsoft’s built-in Power BI apps Per-app, per-company assisted setup: calendar type, UTC offset, date range, report mapping, and a dimension job queue, repeated for each company. Pre-built Cosmos dashboards Included with the add-on. Connect Business Central once, then open all six dashboards.
Licensing Microsoft’s built-in Power BI apps Apps are free to install, but every viewer needs Power BI Pro (or org-wide Premium or Fabric capacity) on top of a paid Business Central seat. Pre-built Cosmos dashboards Delivered through the Cosmos $150/mo company-wide add-on, surfaced inside Cosmos for all your users.

Either way, these dashboards work with Power BI. See how the Power BI integration with Business Central connects your data through a single governed model.

“We’re finally out of the cycle of dumping data and reformatting spreadsheets. We’ve saved time, built confidence, and created consistency across the business.”

Mike Osolinski, VP of Operations

How it works

Three steps to all six dashboards

1

Connect Cosmos to Business Central

Link your Dynamics 365 Business Central environment to Cosmos. Setup typically takes about 30 minutes.

2

Turn on the Power BI add-on

Switch on the company-wide Power BI add-on, $150 per month for all users, per the Cosmos pricing page.

3

Open all six dashboards, day one

Sales, Finance, Inventory, AP, AR, and Purchasing open with your data. Filter, drill through, and customize from there.

Frequently Asked Questions

They are pre-built. Each of the six dashboards is a complete, multi-page Power BI report that already maps to your Microsoft Dynamics 365 Business Central data through Cosmos. You connect your data, and the dashboards are live in minutes. There is no report building from scratch, no SQL and no DAX.

The included free Power BI license covers personal use only. Power BI Pro is required to share reports, view embedded reports in Business Central pages, and run Microsoft’s Power BI template apps. The Cosmos dashboards surface inside Cosmos for all your users through the company-wide Power BI add-on.

With Cosmos, you connect Business Central once, typically in about 30 minutes, and turn on the Power BI add-on. The six dashboards then read from the governed Cosmos data model. A do-it-yourself path uses Power BI Desktop, Get Data, Online Services, Dynamics 365 Business Central; on-premises connects through the OData web service URL.

Microsoft ships free Power BI apps, one per functional area. They install per company, so a multi-company business installs and maintains a separate app and workspace for each company. The installed template app’s model cannot be edited in place; real customization means forking the open-source .pbix and maintaining it yourself. The Cosmos dashboards are cross-company by design, fully customizable and supported, and read from a governed Cosmos warehouse rather than raw Business Central APIs.

On the standard free Power BI path, scheduled refresh is limited to once a day, and Pro is capped at eight scheduled refreshes per day on shared capacity; near-real-time refresh requires paid Premium, Premium Per User or Fabric capacity. Cosmos governs the data through its own cloud engine on a scheduled cadence so the dashboards stay current without each viewer managing refresh.

Every Business Central user gets a free Power BI license, but it is limited to a personal workspace with one scheduled data refresh per day and no sharing. To share reports, view embedded reports inside Business Central, or use Microsoft’s Power BI apps, you need Power BI Pro.

A free license works for personal reports. Power BI Pro is needed for sharing, embedding and the Microsoft template apps. Larger organizations use Premium, Premium Per User or Fabric capacity for higher refresh limits. Cosmos delivers the six dashboards through its own governed engine, so your team works inside Cosmos.

Six functional areas, aligned to how Business Central organizes the business: Sales, Finance, Inventory, Accounts Payable, Accounts Receivable and Purchasing. Cosmos splits Finance, AP and AR into three dedicated dashboards rather than folding payables and receivables into one finance view.

Yes. Power BI reports can be embedded in Business Central pages and viewed without leaving the system, which requires Power BI Pro. Cosmos also surfaces the dashboards inside Cosmos itself, and the two-way Power BI integration lets you display Power BI workspaces from within Cosmos.

The dashboards are built for Business Central online. Cosmos is a cloud solution built on Microsoft Azure, so if you are running on-premises or legacy NAV, book a demo and we will talk through your reporting path.

Ready To Start Your Cosmos Journey?
See all six pre-built Power BI dashboards running on your Business Central data. Book a personalized demo and we will be in touch within two business days.
Book a Demo Book a demo button icon