Skip to main content

Fabric F-SKUs bill 24/7 — right-sizing for peak instead of steady-state overpays 30-50% in year 1. Correct pattern: right-size for the 70th percentile of daily consumption + Autoscale Capacity Units for burst + workload isolation (BI vs data engineering vs data science on separate F-SKUs). Chargeback tier 1 (capacity to BU) or tier 2 (consumption per workload). Weekly/monthly/quarterly FinOps operating rhythm.

Key Facts

  • Biggest mistake: right-size for peak, not steady-state. Right-size to 70th percentile daily consumption + Autoscale for burst.
  • Capacity Metrics App (free from AppSource) shows CU utilization + workload attribution + throttling events. Alert at 70% sustained utilization.
  • Workload isolation when profiles differ: BI (steady, latency-sensitive) vs data engineering (spiky, long-running) vs data science (very spiky). Separate F-SKUs; total spend flat or lower + reliability materially better.
  • Chargeback tier 1 (capacity → BU owner) or tier 2 (consumption per workload). Tier 1 simpler; tier 2 fairer for shared capacity. EPC Group defaults to tier 1, transitions when CoE ready.
  • Operating rhythm: weekly analyst review + monthly CoE governance + quarterly CFO office review.

Last updated by Errin O'Connor, Founder & Chief AI Architect, EPC Group

Microsoft Fabric FinOps & Cost Control

Enterprises typically overpay by 30-50% on Fabric in year 1 without a FinOps discipline. This is the EPC Group playbook.

Frequently Asked Questions

What is the biggest Fabric cost mistake?

Right-sizing based on peak demand rather than steady-state. Fabric F-SKUs bill 24/7 whether workloads are active or not, so an F-SKU sized for the once-quarterly close-cycle peak is oversubscribed 90% of the year. Best practice: right-size for steady-state (roughly the 70th percentile of daily consumption from Capacity Metrics App), configure Autoscale Capacity Units for burst periods, and pay the burst premium only during the peaks. Enterprises that skip this typically overpay by 30-50% in Fabric year 1.

How do we monitor consumption?

The Fabric Capacity Metrics App (installed from AppSource, free) shows CU (Capacity Unit) utilization over time per capacity + per workload + per workspace. Alert threshold: 70% sustained utilization signals need for uplift consideration. The app also shows throttling events (when a workload was rate-limited due to over-consumption) which is the leading indicator that autoscale should be enabled. EPC Group extends this with a Power BI report sourced from the same Fabric admin API showing cost per BU, cost per workload category, and forecast projections.

What is workload isolation and when do we need it?

When you have workloads with radically different resource profiles: data engineering pipelines (spiky, long-running) vs BI reporting (steady, latency-sensitive) vs Data Science training (very spiky, high-consumption). Running all three on one F-SKU means the spiky workloads starve the latency-sensitive ones during peak. Solution: separate F-SKUs — one for BI, one for data engineering + data science. The total F-SKU spend often stays flat because each F-SKU is smaller; the operational reliability improves materially because reports don't slow down during a pipeline peak.

How do we chargeback F-SKU cost to business units?

Two tiers. TIER 1 (capacity-level): assign each F-SKU to a business unit as the primary owner, chargeback the full monthly F-SKU cost to that BU. Simple, aligns incentives. TIER 2 (consumption-level): use Capacity Metrics App data to attribute CU consumption to specific workspaces + workloads, chargeback proportionally per BU based on measured consumption. More complex but fairer for shared-capacity models. EPC Group typically starts customers on Tier 1 for simplicity, transitions to Tier 2 when the CoE has the internal FinOps maturity to run it.

What is the operating rhythm?

Weekly: FinOps analyst reviews Capacity Metrics App, watches for sustained > 70% utilization + throttling events. Monthly: CoE governance meeting reviews spend trend + right-sizing recommendations + workload isolation opportunities. Quarterly: CFO office reviews chargeback allocation + budgets vs actual + F-SKU commit strategy. EPC Group ships the meeting cadence + agenda templates as part of the CoE build engagement.

Talk to a senior architect

Email contact@epcgroup.net or call 888-381-9725.

North America's oldest continuous Microsoft Gold Partner (2000 until Microsoft retired the program in 2022) — today holding all six Microsoft Solutions Partner Designations.

AI assistant — not human