Power BI Pricing Calculator: Pro vs. PPU vs. Fabric F64
Microsoft's official pricing page splits per-user seats ($14 Pro and $24 PPU) from Azure Fabric capacity tables (F2–F2048)—leaving buyers to piece together the actual cost of sharing reports. Use this interactive estimator (cross-referenced with current Microsoft Learn documentation and Microsoft's Licensing Deck) to model your estimated monthly cost and viewer break-even point.
1. Enter Your Users & Requirements
Drag the sliders to update your estimated licensing receipt in real time.
Developers who publish reports. Always require Pro ($14) or PPU ($24)—even on F64 capacity.
Executives, managers, and staff opening dashboards in app.powerbi.com.
Guests who already hold Pro/PPU/E5 in their own home tenant cost you $0.
M365 E5 includes Power BI Pro ($14/mo credit on your receipt, or $10/mo PPU step-up).
Technical & Billing Options
An F8 ($625/mo) supports Copilot & Fabric compute, but does not waive $14 Pro seats for viewers in app.powerbi.com ($1,325/mo combined).
Power BI Pro (Per-User Licensing)
5 Report Authors • 35 Internal Viewers • 10 External B2B Guests (50 Total Users)
Report Creators / Publishers
5 authors × $14.00/mo (Power BI Pro)
Internal Report Viewers
35 viewers × $14.00/mo (Power BI Pro)
External B2B Guests (Host-Licensed)
10 guests × $14.00/mo
$8,400.00/yr • Purchased via Microsoft 365 / Azure (LumioBI is not a Microsoft reseller)
With 45 viewers needing host-paid seats, Power BI Pro ($14/mo) is $4,373/month lower than F64 capacity. (Standard $14 Pro break-even vs. F64 is ~358 paid viewers).
$99.00/mo
Included in budget
Starts a trial of the LumioBI portal layer only ($99.00/mo after trial). You purchase Power BI licenses directly from Microsoft.
$15.98 / user / month across 50 users
$799.00/mo
Who Can View What? The Workspace vs. Viewer License Matrix
The #1 mistake organizations make when budgeting for Power BI is assuming a single creator with a $14 Pro or $24 PPU license can share reports with Free viewers. Here is Microsoft's workspace access matrix:
| Workspace Type Where Report Lives | Fabric (Free) Viewer ($0) | Power BI Pro Viewer ($14/mo) | Premium Per User Viewer ($24/mo) |
|---|---|---|---|
| Power BI Pro Workspace | ❌ No (Blocked) | ✓ Yes | ✓ Yes |
| Premium Per User (PPU) Workspace | ❌ No (Blocked) | ❌ No (Pro users blocked!) | ✓ Yes (PPU required for all) |
| Fabric Capacity F2 – F32 Workspace | ❌ No (Requires Pro/PPU in Service) | ✓ Yes | ✓ Yes |
| Fabric Capacity F64+ Workspace | ✓ Free-license viewers supported (Subject to viewer permissions, capacity CUs & both report + model on F64+) | ✓ Yes | ✓ Yes |
Microsoft Fabric Capacity Pricing & Model Memory Table (F2–F2048)
Microsoft retired legacy Power BI Premium P-SKUs (P1–P5) and transitioned capacity licensing to Microsoft Fabric Capacity Units (CUs). At Microsoft's reference US West 2 rate of $0.18 per CU/hour ($131.40/CU/month), here is what each tier from F2 through F2048 costs, its maximum memory per semantic model, and whether it supports Free-license viewers:
| Fabric SKU | Capacity Units (CU) | Max Model Memory | Legacy P-SKU Equiv. | Pay-As-You-Go / Mo | 1-Yr Reservation / Mo (~40.5% Off) | Free-License Viewers in Service? |
|---|---|---|---|---|---|---|
| F2Min for Copilot | 2 CUs | 3 GB | — (Smaller than P1) | $262.80 | $156.33 | ❌ No ($14 Pro / $24 PPU required) |
| F4 | 4 CUs | 3 GB | — (Smaller than P1) | $525.60 | $312.67 | ❌ No ($14 Pro / $24 PPU required) |
| F8 | 8 CUs | 3 GB | — (Smaller than P1) | $1,051.20 | $625.33 | ❌ No ($14 Pro / $24 PPU required) |
| F16 | 16 CUs | 5 GB | — (Smaller than P1) | $2,102.40 | $1,250.67 | ❌ No ($14 Pro / $24 PPU required) |
| F32 | 32 CUs | 10 GB | — (Smaller than P1) | $4,204.80 | $2,501.33 | ❌ No ($14 Pro / $24 PPU required) |
| F64Free Viewers Unlock | 64 CUs | 25 GB | P1 (8 vCores) | $8,409.60 | $5,002.67 | ✓ Supported (permissions & capacity apply) |
| F128 | 128 CUs | 50 GB | P2 (16 vCores) | $16,819.20 | $10,005.33 | ✓ Supported (permissions & capacity apply) |
| F256 | 256 CUs | 100 GB | P3 (32 vCores) | $33,638.40 | $20,010.67 | ✓ Supported (permissions & capacity apply) |
| F512 | 512 CUs | 200 GB | P4 (64 vCores) | $67,276.80 | $40,021.33 | ✓ Supported (permissions & capacity apply) |
| F1024 | 1024 CUs | 400 GB | P5 (128 vCores) | $134,553.60 | $80,042.67 | ✓ Supported (permissions & capacity apply) |
| F2048 | 2048 CUs | 400 GB | 2× P5 (256 vCores) | $269,107.20 | $160,085.33 | ✓ Supported (permissions & capacity apply) |
Source: Microsoft Fabric Capacity Memory Limits & Microsoft Power BI Licensing Deck (Slide 11 & Slide 17, US West 2 reference pricing). Regional Azure rates vary. OneLake storage ($0.023/GB/mo), networking/egress, and autoscale are billed separately.
Feature Comparison: Power BI Pro vs. PPU vs. Fabric Capacity
| Capability | Power BI Pro ($14/mo) | Premium Per User ($24/mo) | Fabric Capacity (F2–F2048) |
|---|---|---|---|
| Maximum Memory per Semantic Model | 1 GB | 100 GB | 25 GB on F64 (3 GB on F2–F8 • 100 GB on F256 • 400 GB on F1024+) |
| Scheduled Dataset Refreshes | 8 per day | 48 per day | 48 per day |
| Paginated (RDL) Pixel-Perfect Reports | ✓ Included (Supported in Pro workspaces) | ✓ Included | ✓ Included |
| Deployment Pipelines (ALM) & XMLA Read/Write | — | ✓ Included | ✓ Included |
| Copilot AI in Power BI & Fabric | Requires paid F2+ capacity | Requires paid F2+ capacity | ✓ Supported on paid F2+ (Consumes capacity CUs; subject to admin settings) |
| Free-License Viewers in Power BI Service | — | — | ✓ Supported on F64+ only (Subject to viewer permissions, report + model on F64+, & capacity CUs) |
Why Spending Five Figures on Power BI Demands a Better “Front Door”
Whether your calculator result shows $10,000/year for a mid-market Power BI Pro team or $60,000+/year for an enterprise Fabric F64 capacity, licensing is only the engine. Once you add BI developer salaries, your organization is investing over $100,000+ annually to deliver analytics to executives, managers, and clients.
Yet most companies leave their executives with a broken front door:
1. The Multi-Workspace Maze
Native Power BI Workspace Apps only cover a single workspace and cap out at 25 audience groups. Executives shouldn't have to hunt across 12 separate app URLs to see Finance, Sales, and Operations.
2. Session Limits & Cluttered Lists
From the 20-item open report limit to fragmented Workspace vs. App menus, native Power BI is designed for report authors—not busy executives or external clients.
3. The LumioBI Front Door
LumioBI wraps your existing Power BI Pro, PPU, or F64 setup in one clean, branded left-hand navigation menu across every workspace—without writing custom Embedded code or changing Microsoft security.
Common Power BI Pricing & Licensing Questions
If I buy a Power BI Pro license for myself ($14/mo), can I share reports with colleagues for free?
No. Unless both your report and its semantic model reside on a Fabric F64+ capacity ($5,003+/mo reserved) and viewers have appropriate access permissions, every person who opens your shared report or App in app.powerbi.com must also hold a paid Power BI Pro ($14/mo) or PPU ($24/mo) license.
Does Copilot in Power BI still require F64 ($5,003/mo)?
No. While older Microsoft slide decks listed F64+, Microsoft Learn's Copilot requirements confirm that Copilot in Power BI and Microsoft Fabric is now supported on paid Fabric F2 capacity or higher (starting around $156.33/mo reserved), consuming Capacity Units (CUs) from that capacity. However, on F2–F32 capacities, report viewers in app.powerbi.com still need a Power BI Pro ($14/mo) or PPU ($24/mo) license.
Are Paginated Reports (.rdl) included with Power BI Pro, or do I need PPU / F64?
Paginated Reports are included with Power BI Pro ($14/mo)! Microsoft expanded Paginated Report support so Pro users can publish and view .rdl reports in standard Pro workspaces. You only need PPU ($24/mo) or Fabric capacity if you require 48 scheduled refreshes/day, deployment pipelines, XMLA endpoints, or semantic models exceeding 1 GB.
Can an F64 capacity replace any Premium Per User (PPU) semantic model?
Not always. Under Microsoft's Fabric capacity memory limits, an F64 capacity caps individual semantic models at 25 GB of memory, whereas PPU supports up to 100 GB. If your PPU workspace hosts a semantic model between 25 GB and 100 GB, moving to dedicated capacity requires F128 (50 GB limit) or F256 (100 GB limit)—or optimizing the model down below 25 GB.
Can external B2B guests bring their own Power BI Pro or PPU license (BYOL)?
Yes! Under Microsoft Entra B2B guest licensing rules, if an external client or partner already holds a qualifying Power BI Pro, M365 E5, or PPU license in their own home tenant, they can view reports in your workspace at $0 additional licensing cost to you. Use the “Guests Bringing Own License (BYOL)” slider in the calculator above to exclude them from your host-paid seat count.