Power BI for a small business works well when a few people with Microsoft accounts need to explore the numbers, because each person who shares or views shared reports usually needs a paid Pro licence. If the dashboard is mainly for staff, field crews or clients who only need to see a handful of figures, a custom dashboard or a weekly report built from your own systems can cost less over time and be easier to read.
The question that decides it is who reads the dashboard. A disclosure: CentriWeb builds custom software, including dashboards, so weigh our view with that in mind. The Power BI facts below come from Microsoft’s own pricing and documentation pages as at November 2026. Check their pages for current prices.
Power BI and a custom dashboard compared
| Power BI (free) | Power BI Pro | Custom dashboard | Reports in your existing software | |
|---|---|---|---|---|
| What it is | Microsoft’s reporting tool, for your own use | The same, with sharing and collaboration | A screen built around your numbers and your users | The reports already inside your CRM, accounting or job software |
| How it charges | Free, no sharing | Per user a month, paid yearly | A build price, then hosting and upkeep | Included in the plan you pay for |
| Who maintains it | You | You or a Power BI consultant | The developer, under an agreement | The software vendor |
| Who it suits | An owner analysing their own data | A few managers who explore data and are on Microsoft 365 | Many readers, or readers outside the business | Most small businesses, to start with |
What Power BI does well for a small business
Power BI connects to a long list of data sources, from Excel files to accounting and CRM systems, and lets someone confident with data slice the numbers any way they like. Power BI Desktop is free, so you can build reports on your own computer before paying anything. For a business already on Microsoft 365, sign-in and sharing sit inside accounts staff already have.
It suits the owner or finance manager who wants to ask new questions of the data each month, rather than read the same five numbers.
Power BI pricing, as at November 2026
Microsoft shows prices by country, so here is what its pricing pages showed in three regions, all billed yearly:
- United States: the US pricing page showed Pro at $14.00 per user a month and Premium Per User at $24.00. The page shows $ without a currency code and says prices may differ by region.
- Australia: the Australian pricing page showed Pro at AU$21.00 and Premium Per User at AU$35.90 per user a month, not including GST.
- United Kingdom: the UK pricing page showed Pro at £10.80 and Premium Per User at £18.50 per user a month, not including VAT.
The US page also says Power BI Pro is included in Microsoft 365 E5 and Office 365 E5, so check your existing plan before buying. Larger options, Fabric capacity and Embedded, are priced by usage or through sales.
Who reads the dashboard decides the licence bill
Microsoft’s licensing documentation sets out the rules that matter for a small business:
- A free user can create reports and dashboards for their own use, but cannot share them or collaborate with others.
- A Pro user can publish and share content with other Pro users.
- Free users can view content shared with them only when it sits in a Premium capacity or a Fabric capacity of F64 or larger.
For a small business without capacity, the practical result is that everyone who looks at shared reports needs a Pro licence. Some worked examples at the US prices above:
- The owner alone: the free licence may be enough.
- The owner and three managers: 4 x $14 is $56 a month.
- The owner, three managers and 20 field staff who check their numbers: 24 x $14 is $336 a month, or $4,032 a year.
Readers outside the business, such as clients or subcontractors, are a separate question. Microsoft prices that use through Power BI Embedded, which its pricing page lists as contact sales.
Refresh limits and connecting your data
A dashboard is only as current as its last refresh. Microsoft’s data refresh documentation says semantic models on shared capacity, which is where Pro content sits, are limited to eight scheduled refreshes a day. Premium Per User and capacity allow up to 48. If your data lives on a server in the office rather than in the cloud, you need to set up a gateway before scheduled refresh will work.
Eight refreshes a day is plenty for most owners. It matters if staff expect the dashboard to show jobs booked in the last half hour. Ask how often decisions based on the dashboard are made: a weekly decision rarely needs hourly data.
Who builds and keeps the reports right
The licence is the smaller part of the cost for many businesses. Someone has to connect each data source, clean up the data so a job or a customer is counted once, define what each number means, and fix the report when a system changes a field. In a small business that is often the owner on a Sunday, or a consultant paid by the hour.
Before you commit, answer three questions:
- Who will build the first reports, and how many hours will it take them?
- Who fixes a report when the numbers look wrong on a Monday?
- Does everyone agree what “a sale”, “a job” or “a lead” means, so the totals match what the accounts say?
If nobody in the business wants that job, budget for it, whichever option you choose.
What a custom dashboard does well
- No licence per reader. Ten readers or a hundred, the cost is mostly the build and hosting.
- Each person sees only their own numbers. A crew sees its jobs, a manager sees the branch, the owner sees everything.
- It can sit inside a tool people already use, such as a customer portal or a staff app, instead of another login.
- It shows only what matters, which helps when readers are not data people.
The trade-off is that changes need a developer. If you want to explore the data in new ways every week, Power BI’s flexibility is hard to match.
Before either: the reports you already have
Most CRMs, accounting packages and job management systems already include reports. For many small businesses, the right first step is a short weekly email with five numbers, pulled from those systems automatically. Our guide to automated reporting shows how to choose the five numbers and set that up. If your figures live in spreadsheets, see Google Sheets automation for where that works and where it stops.
Where a built and looked-after dashboard fits better, and who it does not suit
A custom dashboard built and maintained for the business fits when many people need a few numbers each, when clients or contractors need their own view, or when the dashboard belongs inside a portal or internal tool you already run. CentriWeb’s custom software work covers that: we build the dashboard over the systems you keep, so each reader sees what they need, and we look after it. For tools of that kind more broadly, see our comparison of internal tools.
It does not suit:
- An owner or manager who likes exploring data and is happy building reports in Power BI.
- A small group already on Microsoft 365 E5, where Pro is included.
- A business whose software already reports what it needs.
- A budget where a few Pro licences do the job.
Where to start
- List who needs to see numbers and which numbers each one needs.
- Check what your existing software already reports.
- Count how many people would need a Power BI Pro licence, and price it on Microsoft’s page for your country.
- Compare that yearly cost with a quote for a custom dashboard, including hosting and maintenance.
- Pick the cheapest option that the people who read it will actually open.