Business Professionals
Power BI | Power Pivot | Power Query | DAX
Cloud Flows | RPA | AI Builder | Copilot
60+ Formulas | Data Stories | Advanced Reporting & Modeling
VB Programming | Report Automation |
MS-Office Automation
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Power BI | Power Apps | Power Automate | Copilot Studio | Power Pages | Dataverse
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Python | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Python | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA | Python |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA | Python
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Databricks | Power Apps | Power Automate |
Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables | Power Apps | Power Automate
Power BI | Power Apps | Power Automate | SQL | VBA | Python | API Integration
Power BI | Advanced DAX | Databricks | SQL | Lakehouse Architecture
Business Professionals
Power BI | Power Pivot | Power Query | DAX
Cloud Flows | RPA | AI Builder | Copilot
60+ Formulas | Data Stories | Advanced Reporting & Modeling
VB Programming | Report Automation |
MS-Office Automation
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Power BI | Power Apps | Power Automate | Copilot Studio | Power Pages | Dataverse
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables
Power BI | Power Apps | Power Automate | SQL | VBA | API Integration
Power BI | Advanced DAX | Databricks | SQL | Lakehouse Architecture
LEARN THIS HANDS ON
Microsoft Fabric & Power BI
Most Fabric rollouts hit the same wall: the reports land, adoption explodes, and suddenly Finance is staring at a licence spreadsheet that looks more like a runway than a budget. The F64 question is simple but uncomfortable: at what point do you stop buying individual Power BI Pro licences and let a Fabric F64 capacity plus free viewers carry the load?
This article walks through the break-even maths in plain terms, using one realistic scenario and current Microsoft licensing behaviour. The goal: give Finance and IT a shared, defensible way to decide whether “above roughly 180 viewers, F64 pays for itself” is actually true for your organisation.
You’ve got:
Today, you’re roughly here:
Finance is pushing back: “We’re already paying for Fabric. Why are we buying so many Pro licences just so people can look at dashboards?”
This is the F64 question.
First, what matters for this discussion is Power BI in Fabric and how capacities interact with viewer licences.
As of late 2024, the relevant pieces are:
Fabric capacity (F SKUs)
Free Power BI users (Power BI “free” licence)
Power BI Pro users
The key behavioural point:
If your Power BI content is hosted on a Fabric capacity (such as F64) and your tenant is configured appropriately, free users can view that content without requiring Pro licences.
This is the mechanism that lets you trade a monthly capacity cost for a large pool of free viewers.
Let’s anchor the scenario in numbers you can adjust.
Assume:
Without Fabric capacity, a common pattern is:
You quickly drift towards:
The total monthly cost is simply:
318 × Pro_unit_priceThe important part is the shape of the cost: it grows linearly with the number of viewers.
Now switch to a Fabric‑centric model:
In the scenario:
You’re now paying for:
Total monthly cost:
68 × Pro_unit_price + F64_unit_priceThe key difference: the cost for viewers is now flat with respect to their count, as long as the F64 capacity has enough headroom for your usage.
Let’s formalise the F64 question.
Define:
C_pro = monthly cost of one Power BI Pro licenceC_F64 = monthly cost of one F64 capacityN_creators = number of people who genuinely need ProN_viewers = number of people who only need to view contentEveryone gets Pro:
(N_creators + N_viewers) × C_proOnly creators get Pro, viewers are free on capacity:
N_creators × C_pro + C_F64We want the point where Model 2 becomes cheaper than Model 1:
N_creators × C_pro + C_F64 < (N_creators + N_viewers) × C_pro
Rearrange:
N_creators × C_pro + C_F64 < N_creators × C_pro + N_viewers × C_pro
C_F64 < N_viewers × C_pro
N_viewers > C_F64 / C_pro
The number of viewers at which F64 pays for itself depends only on the ratio C_F64 / C_pro.
If that ratio is around 180 in your commercial terms, then:
In practice, many organisations see a ratio in that ballpark, which is why “above roughly 180 viewers, F64 pays for itself” is a useful mental anchor. But you should plug your own prices into the formula.
You can drop this into Excel to make it concrete.
=LET(
C_pro, <your_Pro_monthly_price>,
C_F64, <your_F64_monthly_price>,
N_creators, 68,
N_viewers, 250,
Cost_ProOnly, (N_creators + N_viewers) * C_pro,
Cost_F64Model, N_creators * C_pro + C_F64,
BreakEvenViewers, C_F64 / C_pro,
CHOOSE(1,
"Cost with Pro for everyone: " & Cost_ProOnly & CHAR(10) &
"Cost with F64 + free viewers: " & Cost_F64Model & CHAR(10) &
"Break-even viewer count: " & BreakEvenViewers
)
)
Replace the two price placeholders with your negotiated monthly prices. The BreakEvenViewers result is the number that matters in the budgeting discussion.
The maths only helps if the capacity can carry the load.
Before you recommend F64, you need a technical sanity check:
Usage profile
Existing workloads on Fabric
Performance expectations
Within Fabric, you can monitor capacity metrics (CPU, memory, query wait times) to see if F64 is coping:
The finance conversation needs this caveat: F64 is not magic. It’s cheaper than hundreds of Pro licences only if it can actually serve those viewers without degradation.
Even if the numbers say F64 is cheaper, governance can quietly push you back towards more Pro licences if you don’t adjust how you share content.
Key patterns that keep viewer licences free:
Use apps backed by Fabric workspaces
Centralise production content
Tenant settings
If you let teams create and share reports from non‑capacity workspaces “because it’s easy”, you will:
The F64 model works best when content destined for large audiences is always on capacity.
You’ll get better traction if you present the F64 question as a joint decision rather than a licence shopping list.
Plot two lines in Excel:
Total_cost_ProOnly = (N_creators + N_viewers) × C_proTotal_cost_F64Model = N_creators × C_pro + C_F64As N_viewers increases, the gap between the lines is the saving from moving viewers to free on capacity.
Agree on:
This turns the F64 question from “should we buy this SKU?” into “how do we control licence creep while keeping performance acceptable?”
Back to the original team:
Before (Pro everywhere):
After (F64 + free viewers):
Practically, you’ll still have edge cases:
But the dominant cost driver — hundreds of pure viewers — now sits on a fixed capacity line instead of a per‑user licence line.
If your viewer count is heading north of 200 and you already run Power BI on Fabric, sit down with Finance and IT and calculate:
BreakEvenViewers = C_F64 / C_pro
If your current or near‑term viewer count is above that number, it’s time to redesign your sharing model around F64 and free viewers, not to keep buying Pro licences by default.
This article reflects a shift from per-user Power BI licensing to capacity-backed viewing on Fabric, especially relevant for teams where report audiences are growing faster than the pool of content creators.
Professionals who want to apply these patterns to their own data can explore Excelgoodies' Microsoft Fabric & Power BI programme - taught live by instructors, with certification awarded once a real project is running at work.
Insights compiled through ongoing industry research and discussions within the Excelgoodies Analytics Community.
Microsoft Fabric
New
Next Batches Now Live
Power BI
SQL
Power Apps
Power Automate
Microsoft Fabrics
Azure Data Engineering