Everyone asks me how to make Power BI more powerful. Almost nobody asks how to make it cheaper. So let’s do the question nobody puts in a deck: what is the absolute cheapest way to use Power BI?
Short answer: replace your classic reports with the Intelligence Sheet in Microsoft Fabric Plan (built by Lumel) and dress it up with IBCS visuals. Done right, a read-only consumer costs you about $5 per person per month.
Now the honest part: I would not recommend the intelligence sheet as a long-term replacement for Power BI reports, but it is for sure a cost-effective alternative at least in the short run. If a customer is under real cost pressure and wants the cheapest thing that still delivers governed insight — at least temporarily — this is the way to go.
The setup is genuinely three steps
- Buy a Fabric capacity.
- Assign it to a workspace.
- Share the workspace with your users.
That’s it. No license tiers to plan, no agonising over who’s an “editor” and who’s a “viewer.” Fabric Plan meters each person automatically based on what they actually do. Someone only reads? They’re billed as a Viewer. The moment they type a number or build something, the meter reflects it. You stop managing licenses and start paying for activity.
The cost math (this is the fun part)
Fabric Plan uses activity-based pricing — capacity units (CU) consumed, not named users licensed. Here’s the average sustained CU per active user:
| Persona | Triggered by | ~Avg CU (sustained) |
|---|---|---|
| Viewer | Read-only interaction | ~0.05 CU |
| Stakeholder | Data entry / approval | ~0.23 CU |
| Planner | Authoring / admin | ~1.16 CU |
Let’s price a realistic, mostly-read-only audience — exactly the crowd that today sits on a classic Power BI report:
- 498 Viewers + 1 Stakeholder + 1 Planner = ~500 active users → ~26.3 CU of Plan activity.
- That comfortably fits an F32 (32 CU), whose reservation is about $2,501/month (Central US).
One Pro license: optional, but I’d strongly recommend it
Intelligence sheets can sit on top of almost anything — a static CSV or Excel file, or a Fabric Warehouse. But the version you actually want is one built on a proper Power BI semantic model: governed measures, relationships, a single source of truth. For that, exactly one author needs a Power BI Pro license to create and publish the semantic model. That’s it — one license. Every viewer still consumes the model’s data without a Pro license of their own. So Pro is technically optional (you can run on static files or a warehouse), but for a setup you’d actually trust, it’s the one upgrade I’d insist on.
Don’t forget the Fabric resource overhead
That ~26.3 CU is only the Plan activity. Basing the sheets on a semantic model means the capacity also pays for Fabric resource consumption — XMLA reads from the Power BI semantic model, plus Fabric SQL and OneLake. Budget roughly 20% on top: 26.3 CU × 1.2 ≈ 31.5 CU, which still slots inside an F32’s 32 CU. That 20% buffer is exactly why I capped the audience at ~500 consumers rather than cramming in more.
Add it all up — the F32 capacity plus one Pro license for the author, divided across ~500 consumers:
($2,501 F32 + $14 Pro) ÷ 500 users ≈ $5 per person / month
Five dollars a head to put a governed, semantic-model-backed Intelligence sheet in front of a report consumer. That’s the floor.
Treat this as a planning estimate. The 20% Fabric resource overhead (XMLA reads, Fabric SQL, OneLake) is a rule of thumb — depending on model size, refresh patterns and query volume it can be meaningfully more or less, which changes how many consumers an F32 absorbs and therefore the exact per-head cost.
How does that compare to Power BI Pro?
A classic Power BI consumer needs a Pro license at $14/user/month (list price, since April 2025). So:
| Option | Cost per consumer / month |
|---|---|
| Power BI Pro (per-user license) | ~$14 |
| Intelligence sheet (F32, ~500 users) | ~$5 |
Roughly two-thirds off per consumer. Which is exactly the kind of number that makes a CFO lean forward.
Important disclaimer — an F64 can be cheaper. The comparison above assumes per-user Pro licensing. But a Fabric F64 capacity unlocks free Power BI consumption — consumers with a free license can view content in an F64+ workspace, no Pro license required. A single F64 reservation runs about $5,003/month, so above roughly 360 consumers ($5,003 ÷ $14) plain Power BI on an F64 beats both per-user Pro and the per-user Intelligence math. Always run the numbers for your actual headcount before you commit.
Why I still wouldn’t seriously recommend it
Cheap is cheap because it gives things up. Be honest with yourself about the trade:
- Intelligence sheets aren’t Power BI reports. As a Power BI fan, I’ll miss some of what a real report brings — the Office integration and the familiar authoring flow in Power BI Desktop. Here you build in the Fabric Plan experience instead, which is a different way of working.
- Mobile is limited. There isn’t a dedicated mobile experience the way a Power BI report offers one.
Use it when budget pressure is real, the scope is contained, and there’s a genuine plan to revisit. Avoid it when you’re building a platform meant to scale across an organisation.
The takeaway
The cheapest way to put governed, well-designed insight in front of report consumers is the Intelligence sheet plus IBCS, at about five dollars a head. Think of it as a lifeboat rather than your forever-architecture — but if budget pressure is real, now you know it exists, and you know the number.
Numbers are list-price planning estimates. Fabric Plan pricing per Lumel; Power BI Pro pricing and F64 free-consumption per Microsoft Learn. CU rates are region-uniform; dollar cost per CU varies by region.