Fabric F256 capacity
F256 is an enterprise capacity the same size as Power BI Premium P3. Free viewers are allowed, each semantic model can use up to 100 GB, and Direct Lake tables can hold up to 6 billion rows.
- Pay-as-you-go
- $33,638/mo
- 1-yr reserved
- $20,011/mo
- Memory per model
- 100 GB
- Free viewers
- Yes
F256 limits at a glance
| Limit | Value |
|---|---|
| Capacity units (CU) | 256 |
| Equivalent Power BI SKU | P3 |
| Max memory per semantic model | 100 GB |
| Max memory per query | 10 GB |
| Model refresh parallelism | 160 |
| Max concurrent DirectQuery connections (per model) | 100 |
| Direct Lake rows per table | 6 billion |
| Direct Lake Parquet files per table | 5,000 |
| Direct Lake max model size on OneLake | Unlimited |
| Viewers with free licence | Allowed (Viewer role) |
| Copilot | Supported (not on trial capacity) |
What F256 costs
Fabric bills capacity units by the hour. At US East list prices, F256 costs $46.08 per hour, or about $33,638.40 for a full month. A 1-year reservation brings that to about $20,010.67 per month — roughly 40.5% less — in exchange for committing to the size for a year.
Because free-licence viewers are allowed on F256, the comparison that matters is against per-user licensing. A reserved F256 costs the same as about 1,430 Pro viewers (2,403 at pay-as-you-go). Below that, Pro licences are usually cheaper unless you also need Fabric workloads or larger models.
Prices are Microsoft list prices for US East, verified 2026-10-10, and vary by region and agreement.
Is F256 the right size?
Good fit for
- Organisation-wide distribution to viewers on free licences
- Import models up to roughly 50 GB each, or larger Direct Lake models
- Direct Lake tables up to 6 billion rows with no model-size cap on OneLake
Watch out for
- Throttling from smoothed background usage — watch the Capacity Metrics app before scaling up
- Paying for headroom that model optimisation could remove
- Moving up to F512 doubles the bill — confirm the bottleneck first
The usual sizing mistake is choosing a SKU from the average model when the largest model and the morning refresh window decide whether a capacity throttles. The free Fabric capacity estimator checks both.
Compare neighbouring sizes
Fabric F256: common questions
- How much does Fabric F256 cost per month?
- At US East list prices, F256 costs about $33,638.40 per month pay-as-you-go ($46.08 per hour, 256 CUs × $0.18), or about $20,010.67 per month with a 1-year reservation — roughly 40.5% less. Prices vary by region and pay-as-you-go capacity can be paused when idle.
- Do report viewers need a Power BI Pro licence on F256?
- No. On F64 and larger, users with a free Fabric licence and the Viewer role can consume Power BI content. Report authors and publishers still need Pro or PPU. At $14 per Pro licence, F256 costs the same as about 1,430 Pro viewers (reserved) or 2,403 (pay-as-you-go).
- How large can a semantic model be on F256?
- Each semantic model can use up to 100 GB of memory, including refresh overhead. Because a full Import refresh keeps the old copy available while the new one loads, a practical rule of thumb is to keep Import models below about 50 GB, or use incremental refresh. Each query is limited to 10 GB.
- What are the Direct Lake guardrails on F256?
- Up to 6 billion rows and 5,000 Parquet files (and row groups) per table, with no model-size cap on OneLake. If a table exceeds them, Direct Lake on SQL endpoints falls back to DirectQuery (when fallback is enabled), while Direct Lake on OneLake fails to refresh until the table is optimised back under the limit.
- Can I use Copilot on F256?
- Yes. Copilot in Fabric and Power BI requires an F2 or larger capacity (or a P SKU) in a supported region; it is not available on trial capacities. Copilot usage consumes capacity units, so it competes with refreshes and queries on the same capacity.
- Is F256 the same as Power BI Premium P3?
- It is the same capacity size. Microsoft no longer sells P SKUs; each P subscription ends at its agreement term, followed by a 30-day grace period, throttling from day 31 and rejected operations from day 91. Workspaces must be reassigned to an F SKU — and many teams find a right-sized, reserved F256 or smaller is cheaper than a like-for-like move.
Sources: Microsoft Learn — capacity limits, Direct Lake guardrails, Power BI pricing, Premium to Fabric migration, Copilot in Fabric. Verified 2026-10-10.