A plain-English deep dive into Microsoft Power BI for Australian small and mid-sized businesses. Covers what Power BI actually is, the three pieces (Desktop, the Service and data connectors), reports versus dashboards, scheduled refresh, row-level security, Copilot and Microsoft Fabric, the free-to-build and paid-to-share licensing reality with indicative July 2026 AUD pricing, real SME dashboard examples, honest cons, and a side-by-side of five everyday moments with and without a live dashboard.
Microsoft Power BI: turning your spreadsheets into dashboards you'll actually use
Somewhere in your business, someone rebuilds the same report in Excel every month. It is stale by the time it lands, and half the team quotes different numbers anyway. Power BI turns that scattered data into a live dashboard everyone can read at a glance.
The short version
Microsoft Power BI turns scattered spreadsheets and databases into live, visual dashboards you can read at a glance. Instead of someone rebuilding the same monthly report in Excel, the dashboard refreshes itself and everyone sees the same up-to-date numbers.
It comes in pieces: Power BI Desktop (a free Windows app where reports get built), the Power BI Service (the cloud where you publish, share and view them, in the browser and on mobile), and connectors to Excel, databases, Xero, CRMs and hundreds of other sources.
The honest headline: free to build, paid to share. Building costs nothing. Once you want colleagues to view shared dashboards, you generally need Power BI Pro, roughly $13.70 AUD per user per month, or it is included if you are on Microsoft 365 E5.
Prices in this guide are indicative AUD figures current as of July 2026 and subject to change. Confirm with your licensing partner before purchase.
Your numbers, in one place, kept current
Power BI is Microsoft's tool for taking data you already have, spread across spreadsheets, your accounting system, your CRM and databases, and turning it into visual dashboards that anyone can read. Charts, numbers and trends on a single screen, instead of rows and rows in a spreadsheet.
The part that changes how a business runs is this: the dashboard connects to your data once and then refreshes itself on a schedule. No one rebuilds it. The Monday sales screen, the cash-flow view, the job-profitability report, they all stay current on their own. Everyone in the business reads off the same numbers, so the meetings are about what to do, not whose spreadsheet is right.
How the data flows
Many sources feed one model. One model feeds the same dashboard on every device. Update the source, the dashboard updates itself.
Power BI is not one thing, it is three
People say "Power BI" as if it is a single app. It helps to know the three parts, because this is exactly where the free-to-build, paid-to-share line sits.
| The piece | What it does | Who touches it |
|---|---|---|
| Power BI Desktop | A free Windows app where a report gets built. You connect to your data, shape it, build the charts and design the layout. This is the workshop. It costs nothing to download and nothing to use. | Whoever builds the reports: an internal analyst, an accountant, or StartCloud on your behalf. |
| Power BI Service (the cloud) | The online home where finished reports are published, shared and viewed. Staff open dashboards in a web browser or the mobile app. This is where refresh schedules run and where sharing happens. Viewing and sharing here needs a paid licence. | Everyone who needs to look at a dashboard, on a laptop, phone or a screen on the wall. |
| Data connectors | The pipes that pull your numbers in. Power BI connects to Excel, SQL and other databases, Xero and accounting systems, CRMs and hundreds of other sources. Once connected, the data flows in on a schedule you set. | Set up once during the build. After that they run quietly in the background. |
Free to build, paid to share
Power BI Desktop
Free
Connect to your data, shape it, design the report. Nothing to pay.
Power BI Service
The cloud
Push the finished report up to the cloud, set a refresh schedule.
Needs Power BI Pro
≈ $13.70 / user / mo
Everyone who views or shares generally needs a Pro licence.
The build costs nothing. The bill starts the moment colleagues need to view what you have shared.
Reports versus dashboards
A report
A multi-page, detailed document. Think of it as the full picture, with filters and drill-downs, built for someone who wants to dig in.
For example: A five-page sales report broken down by product, region, salesperson and month, where you can click into any figure.
A dashboard
A single screen that pulls the most important visuals into one view. Built for a glance, not a deep dive. Often stitched together from several reports.
For example: One screen on the office wall showing today's sales, cash in the bank, and jobs due this week.
What Power BI actually gives you
Setting aside the product marketing, here is what earns its keep for a small business.
Scheduled refresh
Instead of someone rebuilding the monthly report by hand, Power BI reconnects to your data on a schedule you set: nightly, hourly, or several times a day. The dashboard updates itself and everyone sees the same current numbers. No more emailing spreadsheets around.
One version of the truth
When sales, finance and operations each keep their own spreadsheet, the numbers never quite match. Power BI pulls from the source once and everyone reads off the same model. The argument about whose figure is right mostly goes away.
Row-level security
You can show the same dashboard to different people and have each person see only their slice. A regional manager sees their region, not the whole company. A salesperson sees their own accounts. One report, controlled by who is looking at it.
View anywhere
Once a report is published, staff open it in a web browser or the free Power BI mobile app. No install, no VPN gymnastics. A dashboard can also sit full-screen on a TV in the office, refreshing itself all day.
Copilot: ask in plain English
Power BI now includes Copilot. You can type a question like 'which product line grew fastest last quarter' and get an answer built from your data, without knowing how to build the chart yourself. Handy, though it works best on a well-built model.
Part of Microsoft Fabric
Power BI is now the reporting layer of Microsoft Fabric, Microsoft's wider data platform. For most small businesses this changes nothing day to day. It matters when your data needs outgrow a single report and you start centralising data properly.
Pros and cons
What works well
- Free to build. Power BI Desktop costs nothing. You only start paying when you publish and share with colleagues.
- The dashboard refreshes itself. Set a schedule and the numbers stay current. No one rebuilds the same report every month.
- Everyone reads the same figures. One model, one source, one version of the truth across sales, finance and operations.
- Connects to what you already use. Excel, SQL, Xero, CRMs and hundreds of other sources, so your existing systems feed straight in.
- View on any device. Browser, phone, or a screen on the wall. No heavy install for the people who just need to look.
- Included in Microsoft 365 E5. If you are already on E5, Power BI Pro is bundled in, so there is no extra per-user cost to share.
Where it falls short
- Garbage in, garbage out. A good dashboard needs clean, well-structured source data. If your spreadsheets are messy or your accounting file is a tangle, the report will be too. Tidying the data first is often the real work.
- Building it well takes genuine skill. Data modelling and DAX (Power BI's formula language) are proper skills. A rushed dashboard looks fine and quietly reports the wrong numbers. This is not a five-minute job for most useful reports.
- Everyone who views shared content needs a Pro licence. The build is free, but if fifteen people need to open the dashboard, that is generally fifteen Pro licences. It adds up, and it surprises people who expected 'free'.
- Reports sprawl without an owner. Left alone, a business ends up with forty half-finished dashboards and no one sure which is current. Someone needs to own the reports and retire the dead ones.
- Not the tool for a one-off. If you need a single number once, open Excel. Power BI earns its keep on reports you look at again and again, not on throwaway calculations.
Pricing in real Perth dollars
The key thing to hold onto: building a report is free. You pay when you want to publish and share with colleagues. If you are already on Microsoft 365 E5, Power BI Pro is bundled in, so there may be no extra cost at all.
| Option | Approximate AUD cost | What you get |
|---|---|---|
| Power BI Desktop | Free | The Windows app for building reports. Connect, model, design and publish. No cost, no licence needed to build. |
| Power BI Pro | ≈ $13.70 / user / month | Publish, share and view dashboards in the cloud. The everyday licence for a business sharing reports internally. Included in Microsoft 365 E5. |
| Power BI Premium Per User (PPU) | ≈ $34.20 / user / month | Everything in Pro plus larger data models, more frequent refresh and advanced features. For heavier analytics users, not most viewers. |
| Microsoft Fabric capacity (org-wide) | Fixed monthly capacity fee | Larger organisations buy dedicated capacity instead of per-user Pro licences, so viewers can read reports without their own licence. A different pricing model that suits bigger teams. |
For a small team, the sum is straightforward. One or two people build reports for free in Power BI Desktop. Everyone who needs to open a shared dashboard needs a Pro licence at roughly $13.70 per month. Ten viewers is about $137 a month. Count the viewers honestly before you start, because that is the number that catches people out.
Indicative figures only, quoted before GST. Prices current as of July 2026 and subject to change. Confirm with your licensing partner before purchase.
The dashboards Perth businesses actually build
These are not hypotheticals. They are the four reports small businesses ask us for again and again.
A live sales dashboard
Sales figures pulled straight from your CRM or accounting system, refreshed through the day, on a screen anyone can glance at. Instead of waiting for a Monday report, the team sees where things stand right now: revenue against target, top accounts, what closed yesterday.
Cash flow and debtors
One of the most useful dashboards a small business can have. Cash position, money owed to you, and who is overdue, pulled from Xero or your accounting system. The owner opens one screen instead of chasing the bookkeeper for a number.
Job and project profitability
For businesses that run on jobs or projects, this is the report that changes decisions. Revenue against cost per job, so you can see which work actually makes money and which quietly loses it. Hard to see in a spreadsheet, obvious on a dashboard.
Operations KPIs on the wall
A screen in the office or warehouse showing the numbers that matter to the day: output, orders shipped, safety, whatever the team runs on. It keeps everyone pointed at the same target. StartCloud builds these as part of our custom dashboards service.
A static Excel report versus a live dashboard
These moments happen in every business. In each one, a live dashboard either saves the day or a stale spreadsheet quietly costs you. The question is which column you are in when they come up.
| The moment | The monthly Excel report | A live Power BI dashboard |
|---|---|---|
| The monthly board report | Someone spends the first two days of the month copying figures out of the accounting system and CRM into Excel, tidying charts, fixing a broken formula. By the time it lands, the numbers are already a fortnight old. | The report was built once. It refreshes overnight. On the first of the month it is already current, already formatted, and the person who used to rebuild it is doing something more useful. |
| Two people quote different numbers in a meeting | Sales says revenue is one figure, finance says another. Both are reading their own spreadsheet. The meeting stalls while everyone argues about whose number is right instead of what to do about it. | Both are reading the same dashboard, pulled from the same source. The number is the number. The conversation is about the decision, not the data. |
| The owner wants to check cash on a Sunday | They cannot. The spreadsheet is on someone's laptop at the office. They wait until Monday and ask the bookkeeper, who then has to pull it together. | They open the Power BI app on their phone. Cash position, debtors and overdue accounts, right there, current to last night's refresh. |
| A manager only needs to see their own region | You either send them the whole company spreadsheet, which shows them everything, or you build and maintain a separate cut just for them. Both are a hassle and one is a privacy problem. | Row-level security shows each manager only their slice of the same report. One dashboard, and each person sees exactly what they should. |
| You want to know why last quarter dipped | You export data, build a pivot table, remember how pivot tables work, and hope you filtered it right. An hour later you have a partial answer. | You click into the quarter on the dashboard, or ask Copilot in plain English. The drill-down was built in. The answer is minutes away, not an afternoon. |
The monthly board report
Monthly Excel report
Someone spends the first two days of the month copying figures out of the accounting system and CRM into Excel, tidying charts, fixing a broken formula. By the time it lands, the numbers are already a fortnight old.
Live dashboard
The report was built once. It refreshes overnight. On the first of the month it is already current, already formatted, and the person who used to rebuild it is doing something more useful.
Two people quote different numbers in a meeting
Monthly Excel report
Sales says revenue is one figure, finance says another. Both are reading their own spreadsheet. The meeting stalls while everyone argues about whose number is right instead of what to do about it.
Live dashboard
Both are reading the same dashboard, pulled from the same source. The number is the number. The conversation is about the decision, not the data.
The owner wants to check cash on a Sunday
Monthly Excel report
They cannot. The spreadsheet is on someone's laptop at the office. They wait until Monday and ask the bookkeeper, who then has to pull it together.
Live dashboard
They open the Power BI app on their phone. Cash position, debtors and overdue accounts, right there, current to last night's refresh.
A manager only needs to see their own region
Monthly Excel report
You either send them the whole company spreadsheet, which shows them everything, or you build and maintain a separate cut just for them. Both are a hassle and one is a privacy problem.
Live dashboard
Row-level security shows each manager only their slice of the same report. One dashboard, and each person sees exactly what they should.
You want to know why last quarter dipped
Monthly Excel report
You export data, build a pivot table, remember how pivot tables work, and hope you filtered it right. An hour later you have a partial answer.
Live dashboard
You click into the quarter on the dashboard, or ask Copilot in plain English. The drill-down was built in. The answer is minutes away, not an afternoon.
What Power BI looks like day-to-day
Most people in the business never build a thing. They just open a dashboard and read it. The building is a specialist job done once and maintained quietly. Here is who does what.
| Who | Their experience |
|---|---|
| A staff member who just needs to look | They open a link or the Power BI app, see the dashboard for their team, and get on with their day. No building, no formulas. They need a Pro licence to view shared content, which is usually already in place. |
| Whoever builds the reports | They work in Power BI Desktop: connect the data, shape the model, design the charts, then publish to the cloud. When the business wants a change, they update the report once and everyone sees the new version. |
| The business owner | They get a single screen that answers the questions they used to chase people for. Sales, cash, jobs. On the wall, on the laptop, on the phone. Current, not a fortnight old. |
| StartCloud (custom dashboards service) | We connect your data sources, model the data properly, build the dashboards to answer your actual questions, set the refresh schedules, and maintain them as your systems and needs change. |
From scattered spreadsheets to one clear screen
A dashboard that answers your real questions and stays accurate takes more than dragging charts around. Most of the value is in the parts nobody sees: connecting the data, cleaning it, and modelling it properly. Here is how we approach it.
Step 1. Work out the questions
Before touching Power BI, we sit down and work out what you actually need to see. Not 'a dashboard', but the specific questions: are we hitting target, who owes us money, which jobs make a profit. Good dashboards answer real questions, not vanity charts.
Step 2. Connect and tidy the data
We connect Power BI to your sources: Excel, your accounting system, your CRM, databases. Then we do the unglamorous but important part, cleaning and structuring the data so the numbers come out right. This is where most of the value is won or lost.
Step 3. Model the data
We build the underlying model: how the tables relate, the calculations, the measures. Done properly, this is what lets the dashboard stay fast, accurate and easy to extend later. Done badly, it quietly reports the wrong thing.
Step 4. Build the dashboards
We design the reports and dashboards to be read at a glance: the right chart for each number, a clear layout, and drill-downs where you need to dig deeper. Built for the people who will actually use them, not to show off.
Step 5. Set refresh and access
We configure the refresh schedule so the data stays current, set up row-level security so people see only what they should, and confirm the right licences are in place for everyone who needs to view.
Step 6. Maintain and evolve
Sources change, questions change, the business grows. We keep the dashboards working as your systems shift, add new reports when you need them, and retire the ones that have gone stale so the sprawl never sets in.
Power BI is often at its best when it sits alongside your other systems. If the data needs to move between apps first, we handle that through integrations, and where a report should trigger an action rather than just show a number, Power Automate can pick up where the dashboard ends.
Common pitfalls
-
Building on messy data. If the source spreadsheets are inconsistent or the accounting file is a mess, no dashboard will save you. Fix the data first. A clean, well-structured source is the foundation everything else stands on.
-
Underestimating the licence maths. The build is free, so people plan for zero cost, then discover everyone who views needs a Pro licence. Count the viewers early so the monthly figure is not a surprise.
An efficiency audit maps who genuinely needs to view before you commit.
-
Treating it like Excel. Power BI rewards proper data modelling. Dragging fields around until a chart looks right often produces a dashboard that is confidently wrong. If no one on the team knows DAX and modelling, get help for the build.
-
No one owning the reports. Without an owner, dashboards multiply and go stale. Nobody knows which one is current. Assign someone to own the reports, keep them accurate and retire the dead ones.
-
Reaching for it on a one-off. If you need a single number once, Power BI is overkill. It pays off on the reports you look at again and again, not on throwaway calculations. Know which job you actually have.
Should your business use Power BI?
Yes, if you have numbers you look at more than once and they currently live in a pile of spreadsheets. If someone in your business rebuilds the same report every month, or the team keeps quoting different figures, Power BI is built for exactly that problem.
Be clear-eyed about two things. First, it only works on clean, well-structured data, so budget time for tidying the source. Second, building a genuinely useful dashboard is a real skill, and everyone who views it generally needs a Pro licence, so count your viewers before you commit.
Get those right and the payoff is large. The report that used to eat two days a month builds itself overnight. The owner checks cash from a phone on a Sunday. The whole team argues about decisions instead of whose number is correct. For most Perth businesses, that is well worth the setup.
Where StartCloud fits in
The tool is free to build with. Here is where we plug in.
Build a custom dashboard for your business
StartCloud custom dashboards service
Connect Power BI to your other systems
Integrations between your apps and data
Find where reporting is costing you time
Efficiency audit
Turn a report into an action
Power Automate deep dive
Get the licences sorted
Microsoft 365 for your team
Talk to the Perth team
Get in touch
Still rebuilding the same report every month?
Tell us the numbers you wish you could see at a glance. StartCloud connects your data, builds the dashboard, and sets it to keep itself current, so you stop rebuilding and start reading.
Talk to us about a dashboardNo obligation. Straight answers. Perth-based team.
References
- Microsoft Power BI product page
https://www.microsoft.com/en-au/power-platform/products/power-bi - Power BI pricing (Australia)
https://www.microsoft.com/en-au/power-platform/products/power-bi/pricing - Power BI documentation
https://learn.microsoft.com/en-us/power-bi/ - Reports versus dashboards in the Power BI service
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-reports - Row-level security (RLS) with Power BI
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls - Scheduled refresh in Power BI
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh - Copilot in Power BI
https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-introduction - Power BI as part of Microsoft Fabric
https://learn.microsoft.com/en-us/fabric/get-started/microsoft-fabric-overview
Document prepared July 2026 by StartCloud (Start Technologies Pty Ltd). Pricing and feature information is indicative only and current as of the date of preparation. Microsoft licensing changes frequently, so confirm with your licensing partner before any purchase decision.