Lower Power BI costs per user
Power BI pricing in 2026 at a glance
The per-user price is the small part of the bill.
Power BI is Microsoft's tool for turning company data into shared reports, and how many people view those reports, and how you share them, sets the total, whether the reports go out by hand or through an automated flow built in something like Activepieces.
This holds as of 22 October 2026.
Here's the shape of the four options.
- Free tier: costs nothing, but you can only build for yourself, and others can't view what you make unless it sits in a large enough paid capacity.
- Pro: a low monthly fee per person, and viewers need a Pro licence too, so the cost climbs with every reader you add.
- Premium Per User: a higher monthly fee per person, and viewers need that same licence, so it suits small, heavy-use teams rather than wide audiences.
- Fabric capacity: a flat monthly charge for the capacity itself, and at larger sizes people on the free tier can view reports, so a wide audience stops costing per head.
Which one's cheaper depends on how many people read your reports.
What Power BI is and what it's licensed on
You pay for two things: the people who build and read reports, and the computing power that refreshes the data behind them. Per-user licences cover the first. Capacity covers the second, and at larger sizes it also covers who may view.
If you are running this arithmetic for your own team, see what the same workload costs on Activepieces.
All Power BI plans, prices and limits
Of the five plans that cover every Power BI case, only two are priced per person, so the table below is where you decide who pays and who just views.
| Plan | Price | Who can share | Max dataset size | Daily refreshes | Key features | Check date |
|---|---|---|---|---|---|---|
| Free | $0 | Nobody; personal use | 1 GB | 8 | Build reports for yourself | Not price-checked |
| Pro | $14 per user per month | Other Pro users | 1 GB | 8 | Publish and share workspaces | April 2025 report |
| Premium Per User | $24 per user per month | Other PPU users | 100 GB | 48 | Larger models, more refreshes | April 2025 report |
| Fabric F SKUs | Billed by capacity size | Viewers on larger sizes need no Pro licence | Set by capacity size | 48 | Shared pool of compute | Price not confirmed |
| Embedded A SKUs | Billed by capacity size | Outside users, through your own app | Set by capacity size | 48 | Reports inside your product | Price not confirmed |
"Larger sizes" has a specific threshold. Free-licence viewing starts at F64, the size equivalent to the old Premium P1. The smaller F SKUs, F2 through F32, still need a Pro licence for every viewer, so they bring the flat compute but not the free audience.
Recent price and licensing changes
In April 2025, Pro rose from $10 to $14 per user per month, and Premium Per User from $20 to $24, according to The Register. That's a 40 percent jump on Pro, so a 200-person rollout costs $9,600 more per year than it did.
I couldn't confirm F prices, so check Microsoft's calculator before you budget.
What Power BI costs at different audience sizes
Per-user licences cost headcount times price, while a capacity costs the same whether 100 or 1,000 people look, so the cheapest choice changes as your audience grows.
Call the Pro price per user P, the Premium Per User price U, and the monthly Fabric capacity price C, all taken from Microsoft's calculator.
C must be the price of F64 or larger, not the cheapest F SKU. A smaller capacity still needs Pro for every viewer, so it never delivers the free-viewer column below. F64 is the size to look up in Microsoft's calculator.
| Viewers | All-Pro | PPU for everyone | Fabric capacity, free viewers |
|---|---|---|---|
| 10 | Monthly 10 × P, annual 120 × P. Every viewer needs Pro. | Monthly 10 × U, annual 120 × U. Every viewer needs PPU. | Monthly C, annual 12 × C. Viewers need no licence. |
| 100 | Monthly 100 × P, annual 1,200 × P. Every viewer needs Pro. | Monthly 100 × U, annual 1,200 × U. Every viewer needs PPU. | Monthly C, annual 12 × C. Viewers need no licence. |
| 1,000 | Monthly 1,000 × P, annual 12,000 × P. Every viewer needs Pro. | Monthly 1,000 × U, annual 12,000 × U. Every viewer needs PPU. | Monthly C, annual 12 × C. Viewers need no licence. |
Add the report builders to C, because they still need their own paid licence under the capacity option.
At ten viewers, 10 × P is small and predictable, while a capacity is a monthly commitment whether or not anyone opens a report.
At 100 viewers you're in the crossover zone. Here 100 × P starts to rival C, and 100 × U may already pass it.
Divide C, the F64 price, by P to find how many Pro viewers equal one month of capacity. If your real audience is above that figure, capacity wins. If it's below, Pro still does.
At 1,000, per-user pricing multiplies into the largest line of the three, and it grows with every hire. Capacity stays flat, which is why it usually wins at this size.
People outside your company are the other trigger: if they must see reports without buying licences, embedding on a capacity is the route to price first.
Hidden Power BI costs that inflate bills
Of the six places the bill outgrows the per-user price, embedding is only one, and the other five are quieter.
- Pro licences for every viewer when reports are not on a capacity
- Dataset size and refresh caps that push you to a bigger tier
- A capacity left running overnight and at weekends
- Embedded for external customers
- A gateway server to reach data inside your own building
- Admin time to keep all of it working
Off a capacity, everyone who opens a shared report needs a Pro licence, so a 200-person audience means 200 licences before anyone has built anything.
If a team wants hourly numbers, it is pushed onto a capacity whether or not it wanted one, because Pro caps a dataset at 1 GB and refreshes it eight times a day.

Power BI Embedded pricing and capacity sizing
Every size up doubles the last, and embedded capacity is billed by the hour. According to Mammoth, A1 is $1.0081 an hour and A2 is $2.0081.
A3 is $4.0242, A4 is $8.0565, A5 is $16.121 and A6 is $32.25, so each tier up roughly doubles your ongoing spend.
Left on around the clock, A1 comes to roughly $736 a month and A6 to about $23,500.
Power BI gateway, Fabric and admin costs
To reach data kept in your building, the cloud needs a gateway, a small program on a server. That server needs hosting, patching and someone watching it.
Heavy refreshes draw down the same pool your reports rely on, because Fabric, Microsoft's wider data platform, bills by capacity use.
Admin time's the cost nobody quotes: when no one owns it, reports fail quietly and the first you hear's a manager asking why numbers are old.
Worth checking against a plan that does not meter every step: one credit covers a whole run on Activepieces.
Power BI as the affordable option
For a company already on Microsoft 365, the licence's close to a rounding error on a bill it already pays, and that is why Power BI looks cheap.
Admin time's the cost nobody quotes: when no one owns it, reports fail quietly and the first you hear's a manager asking why numbers are old.
The case for Power BI as the bargain
At $39 per user per month, Microsoft 365 E3 is the base. Adding Power BI Pro costs $14 on top, so E3 plus Pro comes to $53.
Microsoft 365 E5 costs $60, which means $7 more than that combination buys the other E5 features.
Because report authoring in Power BI Desktop is free, and the tool sits next to Excel, Teams and SharePoint, staff learn less and IT integrates less.
When Power BI is actually cheap
It holds when most of your people already have these licences. It breaks when the audience, the embedding or the refresh load grows beyond what a seat price covers.
| Situation | Does the cheap argument hold? | Why | What the bill depends on |
|---|---|---|---|
| Small Microsoft 365 shop | Yes | Licences are mostly already paid for | Whether everyone who needs reports has Pro |
| Many internal viewers | Partly | Per-seat cost multiplies with every reader | Headcount of viewers versus buying capacity |
| External embedding | No | Customers and partners are not your licensed staff | Capacity size and how many outsiders view |
| Heavy refresh | No | Frequent, large refreshes outgrow shared limits | Refresh frequency and data volume |
Below the first row, each swaps a known seat price for a capacity decision, and that decision, not the $14, sets the total, so you can't lock in a price based solely on your headcount.

Power BI pricing versus competitors
On entry price per user, Power BI's the one to beat. Its rivals charge for viewers and embedding in different ways, and that's where the totals split apart.
| Entry per-user price | Free tier | How viewers are priced | Embedding model | Check date | |
|---|---|---|---|---|---|
| Power BI | Lowest of the paid options for a single builder | Free authoring, but sharing needs a paid licence or capacity | Each viewer needs a licence unless you buy capacity | Capacity-based | Confirm on the day you buy |
| Tableau | Higher, and priced by role | Free public-sharing option only | Cheaper viewer role, still paid per person | Separate embedded licensing | Confirm on the day you buy |
| Looker Studio | Free; paid Pro tier adds team controls | Yes, for most reports | Viewers generally need no licence | Free report embeds; Looker for governed embedding | Confirm on the day you buy |
| Qlik | Tiered by plan | Trial rather than a permanent tier | Viewer-style users priced separately, with data volume also counting | Capacity-based | Confirm on the day you buy |
Only one of the four makes most viewers free without a paid capacity, and that's Looker Studio. The catch is governance: it's lighter on access control and shared definitions.
If your data is large or refreshes often, get a quote before comparing Qlik against Power BI's per-user figure.
What to check before buying Power BI licenses
Run a short check on your people and your data before you buy anything.
- Tally your people in three groups: authors (who build reports), internal viewers (staff who only read them) and external viewers (clients or partners outside your company). The viewer counts decide whether per-user licences or a shared capacity is cheaper.
- Write down how often each report needs fresh data and roughly how large the data is. Frequent refresh and big datasets are what push you past the limits of a per-user licence.
- Price the same audience both ways, per user and on a capacity, and find the headcount where the shared option becomes cheaper.
- Trial Premium Per User (PPU) or a capacity with your real reports and real viewers before committing. A trial shows you refresh failures and slow reports that a price list never will.
- Prices and terms change, so check the current figures on Microsoft's live page yourself rather than relying on any article, this one included.
Where workflow automation fits
A workflow automation tool can pull records from the software-as-a-service (SaaS) apps your team already uses, such as your CRM or billing system, and load them somewhere Power BI can read.
It can also send alerts when a report shows something that needs attention. Activepieces does this work, with 744 integrations in its MIT-licensed open source repository. It doesn't replace Power BI or change its pricing.
What Activepieces does about this
Activepieces doesn't change what Power BI charges. It works on the two inputs that drive the bill, refresh load and audience.
You can build a flow that pulls records from your CRM or billing system on a schedule and writes them to a database or sheet that Power BI reads. The flow runs outside Power BI, and you can see each run.
The meter is simple. A run costs one credit whether it has two steps or ten, and the free plan includes 1,000 credits a month with unlimited flows, so you can test whether this tool works for your team before spending.

Count your runs before you decide the feed needs a bigger tier. The code is MIT-licensed, so you can also self-host it and skip the credit meter.
Our 744 integrations cover most CRM and billing sources without custom work, which means your team probably won't need to build connectors.
Alerts are the audience lever. A flow can message Slack or email when a figure crosses a threshold, so someone who only needs to know "revenue dipped" never opens a dashboard.

That is a message, not a report, so it won't replace a Pro licence for anyone who needs to explore the data. It can still shrink the viewer count you price in step one of the checklist.
Frequently asked questions
Ask about alerts and dashboards and the same licensing questions come back each time; these four have short answers in Microsoft's documentation.
Building reports on your own machine costs nothing, because Power BI Desktop is free to download and use.
The cost starts when you publish to the Power BI service and share, because that step needs a licence for you and, in most setups, for the people reading.
Do viewers need a Pro licence to see shared reports?
Usually, yes. Microsoft's docs say that sharing in the standard way requires viewers to hold Pro or Premium Per User licences as well.
There is one exception: content hosted in a workspace on a large enough Fabric capacity, where viewers with a free licence can read it. So the licence you pick depends on how many readers you have. Count them before you choose.
Can I pause a Fabric capacity to stop charges?
Yes, with limits. A pay-as-you-go capacity can be paused in the Azure portal, and compute billing stops while it's paused. Anything running on it stops too, so reports and scheduled refreshes go dark.
Pausing doesn't help with a reserved capacity you have already committed to, and stored data may still be billed. If people rely on reports overnight, check what pausing will break before you do it.
Because Microsoft's licensing documentation lists Power BI Pro as part of the Microsoft 365 E5 suite, those users don't need a separate Pro purchase. E5 doesn't include a Fabric capacity, so a large audience of free-licence viewers or heavy refresh still needs capacity bought separately.
Related reading
References
Running the numbers
See what the same workload costs here.
Free forever plan, and every paid plan self-hosts at no extra cost.
See pricing Talk to sales
