Power BI licenses or a Microsoft Fabric capacity?
Power BI is one workload inside Microsoft Fabric, so the real choice is licensing. Pro and Premium Per User are per-user Power BI licenses; a Fabric F capacity, bought through Azure, unlocks lakehouses, warehouses and notebooks and, from F64 upward, lets free-license viewers read Power BI content.1
How they relate
Different layers. They sit at different layers of the stack, so the question is usually which layers you need, not which one wins.
Power BI and Microsoft Fabric are not separate products to pick between. Fabric lists Power BI as one of its workloads on OneLake, and one Microsoft licensing page covers both. What you actually choose is a mix of per-user licenses (Free, Pro, Premium Per User) and, optionally, a capacity: a Fabric F SKU bought through Azure or, for some existing customers, a Power BI Premium P SKU.
Microsoft draws the lines clearly. A Pro license is needed to create Power BI items outside My workspace and share them. Premium Per User (PPU) adds most Premium features per user, including 48 refreshes a day, semantic models over 1 GB and the XMLA endpoint, and Microsoft calls it more cost effective when fewer than 250 users need those features. PPU does not provision a Fabric capacity, so it gives no lakehouses, warehouses or notebooks. F capacities are billed per second through Azure with no commitment and are Microsoft's recommended capacity. On F64 or larger, users with only a free license and a viewer role can view Power BI content; below F64 each viewer still needs Pro or PPU.
P SKUs are available only to customers who have them on an active Enterprise Agreement, and Microsoft is retiring the Power BI Premium per-capacity SKUs, advising new and existing customers to consider F SKUs instead. Microsoft has also renamed license mode to workspace type, a terminology change only. In our view, a small team that only builds and shares reports may need nothing beyond Pro licenses; a capacity pays off when you want Fabric items or many read-only viewers.12
The technologies
Platform
Power BI
Power BI is Microsoft's business intelligence platform: Power BI Desktop to model data and build reports, the Power BI service to share and govern them, and mobile apps to view them. It is also a core workload of Microsoft Fabric, and capacity licensing is moving from Power BI Premium P SKUs to Fabric F SKUs.
Cloud application
Microsoft Fabric
Microsoft Fabric is Microsoft's SaaS analytics platform. Data integration, Spark data engineering, warehousing, real-time analytics, data science, operational databases and Power BI share one lake (OneLake) and one capacity-based license, so teams do not have to wire separate Azure services together.
Which fits which goal
| If your goal is | What fits | Why |
|---|---|---|
| Create and share Power BI reports in a small team | Power BI | Microsoft lists Pro licenses as an option for creating and sharing Power BI content only, and a Pro or PPU license is required to create Power BI items outside My workspace.1 |
| Use Premium features such as large models and the XMLA endpoint for under 250 users | Power BI | Microsoft says Premium Per User is more cost effective when Premium features are needed for fewer than 250 users, although it does not enable Fabric workloads.1 |
| Build lakehouses, warehouses or notebooks alongside your reports | Microsoft Fabric | Creating non-Power BI Fabric items requires an F capacity or a Fabric trial capacity; Pro and PPU licenses alone do not provide one.1 |
| Let a large organization view reports without a paid license per viewer | Microsoft Fabric | On an F64 or larger capacity, users with a free license and a viewer role on the workspace can view Power BI content.1 |
| Try the full platform before committing to a capacity | Microsoft Fabric | Microsoft offers a 60-day Fabric trial capacity that includes the equivalent of an F64 capacity.1 |
No technology here is ranked. Pricing and performance are left out on purpose: they depend on your models, hardware and contract, so measure them in a pilot.
Sources
Thank you. Your correction was sent.
The editors check it against the sources. If you left an email address, they may reply about it.