Power BI for Small Business, or a Custom Dashboard? Skip to content
CentriWeb
Not sure where to start?

Tell us how the business runs. We'll tell you what we'd build first.

Book a call
For builders and tradesPreBuildMore homeowner enquiries, more trust, more jobs won. For sole tradersOwner CFOA financial operating system for owners who do the books.
Need something of your own?

We build custom software too.

Talk to us

Power BI for a small business, or a custom dashboard?

Power BI suits a few people who explore data. When many people need a few numbers each, licence costs add up and a custom dashboard can fit better.

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

  1. List who needs to see numbers and which numbers each one needs.
  2. Check what your existing software already reports.
  3. Count how many people would need a Power BI Pro licence, and price it on Microsoft’s page for your country.
  4. Compare that yearly cost with a quote for a custom dashboard, including hosting and maintenance.
  5. Pick the cheapest option that the people who read it will actually open.

Common questions.

Is Power BI free for a small business?

Power BI Desktop and the free licence let one person build reports for their own use. To share reports with others, Microsoft's documentation says you need Pro or Premium Per User, unless the content sits in a Premium or F64 or larger Fabric capacity.

How much is Power BI Pro?

As at November 2026, Microsoft's pricing pages showed Pro at $14.00 per user a month in the United States, AU$21.00 plus GST in Australia and £10.80 plus VAT in the United Kingdom, all billed yearly. Check Microsoft's page for your country.

Do people viewing a Power BI report need a licence?

On shared capacity, yes: Pro content can be shared with other Pro users. Free users can view shared content only when it is in a Premium capacity or a Fabric capacity of F64 or larger.

What is a custom dashboard?

A screen built for your business that pulls numbers from your own systems and shows each person the figures they need. It costs a build price and upkeep instead of a licence per reader.

Related guides.

Custom software · 7 min read

AI app builder or a developer: can AI build your app?

Custom software · 5 min read

Internal tools: Retool, a low-code builder or custom

Custom software · 6 min read

Airtable alternatives: when to move to a proper database

Talk to CentriWeb about this

CentriWeb plans and builds portals, web apps and internal tools, and helps businesses decide when building beats buying.

CentriWeb is based in New Zealand and works online with businesses worldwide.

Want this working in your business? We'll map it with you on a call.

A 30 minute call. You'll leave knowing what we'd build first.

Book a call