Power BI Cost Analysis: Pro, Premium Per User and Fabric Capacity for 50 to 500 Staff

Power BI licensing looks simple until you try to budget for it. Pro, Premium Per User, Fabric capacity, F2, F64, reserved pricing, pay as you go. For a business with 50 to 500 staff, choosing the wrong model can mean paying for features you do not use, or hitting limits that slow your reporting down.
This guide breaks down the three main options, shows worked examples at different company sizes and explains where the break-even points sit.
A note on prices: Microsoft publishes list prices in US dollars and adjusts local currency pricing by region. The figures below use Microsoft's published US list prices at the time of writing for comparison. Australian prices and Azure region rates differ, and Microsoft changes pricing from time to time. Always confirm current pricing with Microsoft or your licensing partner before you commit.
1. The three licensing models
Power BI Pro
Pro is a per-user licence. Every person who creates, shares or views shared content needs one, unless the content sits on an F64 or larger capacity.
List price: US$14 per user per month
Model size limit: 1 GB
Scheduled refresh: up to 8 per day
Included in Microsoft 365 E5
Premium Per User (PPU)
PPU is also a per-user licence, with most Premium features.
List price: US$24 per user per month
Model size limit: 100 GB
Scheduled refresh: up to 48 per day
Adds features like deployment pipelines, larger models and advanced AI features
Everyone who views PPU content also needs PPU
Fabric capacity (F SKUs)
Fabric capacity is bought as compute, measured in capacity units (CUs), from F2 up to F2048. You pay for the capacity, not per user, although report creators still need a Pro or PPU licence.
Pay-as-you-go in US regions is about US$0.18 per CU per hour, so an F2 is roughly US$263 per month and an F64 roughly US$8,410 per month if left running
Reserved capacity for one year reduces this by roughly 40%, bringing an F64 to around US$5,000 per month
At F64 and above, users with a free Fabric licence can view Power BI content without a Pro licence
Includes the wider Fabric platform: lakehouse, warehouse, data pipelines, notebooks and Copilot features
2. Worked examples
These examples are simplified to show the logic. Actual costs depend on your mix of builders and viewers and on regional pricing.
Company A: 60 staff, 40 report users
40 Pro licences at US$14 = US$560 per month
Models are under 1 GB and daily refresh is enough
Best fit: Pro. Simple and low cost. If you already have Microsoft 365 E5, Pro may already be included.
Company B: 150 staff, 100 report users, larger models
100 PPU licences at US$24 = US$2,400 per month
Gives 100 GB model limits and up to 48 refreshes a day
Or:
100 Pro licences at US$14 = US$1,400 per month
Plus an F2 to F8 capacity for Fabric data engineering, from about US$263 per month for F2
Best fit: depends on needs. If the main need is bigger models and faster refresh, PPU is simple. If you also need a lakehouse and pipelines, Pro plus a small Fabric capacity often works better.
Company C: 400 staff, 350 viewers, 20 builders
Option 1: 370 Pro licences at US$14 = US$5,180 per month
Option 2: F64 reserved at about US$5,000 per month plus 20 Pro licences for builders at US$280 = about US$5,280 per month
Best fit: close to break-even. At this size, F64 starts to make sense, especially if you also want Fabric data engineering, Copilot and the option to add more viewers without extra licences.
3. Where the break-even sits
A rough rule using US list prices:
An F64 reserved capacity costs about the same as 350 to 360 Pro licences
An F64 pay-as-you-go capacity left running all month costs about the same as 600 Pro licences
So for organisations with fewer than about 300 viewers, per-user licensing usually costs less. Above that, or where many external or occasional viewers need access, F64 becomes attractive.
4. Hidden costs to plan for
Builders still need licences. Even on F64, people who create and publish content need Pro or PPU.
Capacity sizing. An undersized capacity throttles under load. An oversized one wastes money.
Pausing capacity. Pay-as-you-go capacity can be paused when not in use, but reports on it stop working while paused.
Data storage. OneLake storage is billed separately from compute.
Gateways and infrastructure. On-premises gateways need a server to run on.
Copilot. Copilot and Fabric data agents need F2 or higher Fabric capacity, or P1 or higher Premium capacity.
5. Decision guide
Your situation | Likely best fit |
Under 100 users, small models, daily refresh is fine | Pro |
Under 300 users, need bigger models or more refreshes | PPU |
Need Fabric data engineering but modest user count | Pro plus small F SKU |
300 or more viewers, or many occasional viewers | F64 plus Pro for builders |
Want Copilot and data agents | Fabric capacity F2 or higher |
6. How to reduce Power BI costs
Audit licences and remove inactive users each quarter
Separate builders from viewers and license accordingly
Use reserved capacity for steady workloads
Optimise models to reduce capacity usage
Pause development capacities outside working hours
7. How GrowthBI helps
GrowthBI helps mid-market businesses with $30M to $500M in revenue choose the right Power BI and Fabric licensing, size capacity correctly and optimise models so you are not paying for waste.
GrowthBI pricing
Project pricing: $5,000 to $30,000 AUD per project, depending on scope.
Ongoing support and administration: from $2,000 per month.
Timeline
A licensing review and optimisation project typically takes 1 to 6 weeks, depending on the size of your tenant.
Learn more about our Power BI consultants in Melbourne.
Frequently Asked Questions
How much does Power BI Pro cost?
Microsoft's US list price for Power BI Pro is US$14 per user per month. Australian pricing differs, so confirm current local pricing with Microsoft or your licensing partner.
What is the difference between Pro and Premium Per User?
PPU adds larger model sizes, more scheduled refreshes and advanced features. Everyone who views PPU content also needs a PPU licence.
When does Fabric F64 make sense?
F64 suits organisations with roughly 300 or more viewers, or many occasional viewers, because users with a free licence can view content on F64 and above without Pro.
Do report creators need a licence on Fabric capacity?
Yes. People who create and publish Power BI content need a Pro or PPU licence, even when content is hosted on Fabric capacity.
Can I pause Fabric capacity to save money?
Pay-as-you-go Fabric capacity can be paused, which stops compute charges. Reports on that capacity are unavailable while it is paused, so this suits development or scheduled workloads.
Pay for What You Use
The right Power BI licensing mix depends on how many people build, how many view and how much data you work with. A short review can often reduce costs while improving performance.
Book a free consultation with GrowthBI to review your Power BI licensing.