22-25 April 2026

Fabric FinOps - Cost Optimization for Fabric

Proposed session for SQLBits 2026

TL; DR

Microsoft Fabric's "fixed pricing" is just the start - optimizing capacity units across workloads is key. This session covers CU concepts, workload efficiency, and the bigger picture beyond technology costs.

Session Details

A software-as-a-service offering such as Microsoft Fabric offers a fixed cost per month, making budgeting much easier. That should be the end of the conversation, but it's actually only the beginning - how do you make the most of the capacity units you get with the fixed price? How can you ensure that you are getting the most out of your monthly investment? The different Fabric workloads all have different ways of using capacity units - some are cost CUs per minute of runtime, some cost per query, some are straight forward to calculate, some are not.

Take dataflows gen 2 an an example - it used to be the most expensive way by far of doing data integration compared to pipelines or copy jobs, but what does "expensive" mean in the grand scheme of things? Depending on your organization's previous experience and skill level, dataflows might instead end up being the cheapest option!
There is much more to optimizing the bang for your buck with Fabric than only looking at the relative costs of capacity units, as it is easy to get lost in the technology instead of looking at the big picture.

This session will look at capacity units as a concept, compare how the different workloads drive capacity unit usage, explore ways to optimize workload usage to decrease compute costs, and discuss other factors that impact the overall cost conversation around Fabric.

3 things you'll get out of this session

Introduce Capacity Units (CUs) Identify cost drivers in Fabric Explore ways to optimize workload usage

Speakers

Alexander Arvidsson

arcticdba.se

Alexander Arvidsson's previous sessions

Roche's Maxim of Data Transformation - By Example
Roche's Maxim of Data Transformation states that "data should be transformed as far upstream as possible, and as far downstream as necessary". Simple, powerful, and beautiful - but what does it really MEAN? Come find out through example.
 
Stand Fast - How Governance Can Save You a Fortune
Why is it that cloud projects often end up way more expensive than they should? The answer might surprise you: a lack of governance. Come learn how to turn governance from limitation to enablement.
 
Knee-Deep In Tech Live @ SQL Bits
Come be a part of the audience for a recording of an episode of Knee-Deep in Tech, a bi-weekly technology podcast! The topic for this year's recording is: Agile, DevOps; DataOps and all the other methods - help or hindrance?
 
The Untruthful Art - Five Ways of Misrepresenting Data
In this age of information it is imperative to be able to be able to clearly, simply and accurately explain and communicate sometimes complex data.
 
+5 Wisdom - Learn to Ask Better Questions to Solve the Right Problems
By asking the right questions we can solve the actual problem - not only the problem we think we are facing. Take a step back, look further, and ask better questions. We'll show you how.
 
Spell of Transmutation - Using Debezium to Transfer Realtime Data Changes to Event Hub
Getting changes from SQL Server to Event Hub can be tedious. I'll show you how to set up Debezium to automate SQL Server change data capture into Event Hub and explain why this matters for your serverless architecture!
 
Knee-Deep In Tech Live @ SQL Bits
Be part of a live audience recording of an episode of Knee-Deep in Tech!
 
Learning to Listen - Making the Most of Mentoring
Being a mentor or a mentee offer amazing opportunities but come with their own sets of challenges. We'll help you make the most of mentoring!