22-25 April 2026

Understanding Fabric Capacities

Proposed session for SQLBits 2026

TL; DR

An introduction to Microsoft Fabric Capacities: what they are, how they work, how they compare to Power BI Premium, what they cost, and how to size, manage, monitor, and automate them to support business needs confidently.

Session Details

You've heard about Microsoft Fabric, and you're ready to take it for a spin? Excellent, let's get us started off in those few advertised minutes! But hold on .. you need a capacity to actually use something, and might not be completely clear on what it actually entails? You're not alone with these questions, and it is perfectly fine to stop and think about it for a while. In fact, it's a good thing you want to understand the single most core concept of Fabric as that will hopefully allow you to make better decisions down the road.

The introduction of Fabric Capacities sparked a lot of questions with Data Architects, Engineers, and Analysts coming from an IaaS or Paas (Infrastructure or Platform as a Service) way of working. Microsoft Fabric is presented as an all-in-one Analytics SaaS (Software as a Service) solution, with a unified measure for Compute and Storage. Great, promising to make the cost and performance predictability a lot simpler. Great! But what exactly does that mean, and what will it actually cost the company?

To understand Fabric Capacities, we need to briefly look at the architecture and what exactly those unified measures look like, including how they are similar, yet different from the existing Power BI Premium Capacities. Understanding the different types and sizes of capacities will help us make the right decisions for our Data Platform solutions in the organization.

But then, how do you manage those capacities and assess if they are in a healthy state? What are some of the options to follow the demands and needs of your business users to allocate the right resources to them? Most importantly, what options do I have to automate the majority of these tasks?

Walking out of the session, you should understand the key concept of Fabric Capacities and how they are at the core of everything you'll do in Microsoft Fabric, be able to choose the one that is right for you, periodically assess if the choice was right, and act where needed.

3 things you'll get out of this session

- Explain what Microsoft Fabric Capacities are and why they are central to the platform - Understand the unified compute and storage model in Fabric and its cost implications - Select appropriate capacity types and sizes based on workload requirements - Monitor and assess capacity health and usage - Apply management and automation options to adapt capacity to changing business needs

Speakers

Benni De Jagere

bennidejagere.com

Benni De Jagere's previous sessions

Nose-Dive Narratives: Slide Karaoke 2024
Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!
 
Asking questions to get meaningful answers
By making sure we're supplying the other party with the compact information they need, and making sure we're "forcing" them to give a decent answer, there's a lot more information we can receive. By getting the information we need, we'll be able to proceed quicker, and getting to results faster.
 
Setting yourself up for success when submitting to present
During this session we'll cover how you find those elusive speaking opportunities and how you can make the most of it with just a few simple things to keep in mind. Most importantly, what can you do to help understand organizers or selection committees why exactly your session would be a good fit for them, and why you think it would be a good fit for their audience.
 
Star Schema ALL the things! But why?
Come along in this journey from source to model to report using a practical mindset, thinking about the design decisions and ramifications along the way. At the core of the session lies the message to think about best practices, with the added step to test, assess, and benchmark what exactly they do for you.
 
You're a Power BI Admin? Let's get your threads aligned for Fabric!
This session will focus on the life of a Power BI Admin moving over to the extended Fabric realm, and keeping their things in check. We'll look at the familiar topics of capacity and workspace management, and how they align with the new workloads that have been introduced. We'll notice there's a very large overlap, as Fabric has been built on the foundations of Power BI.