Understanding Fabric Capacities
Proposed session for SQLBits 2026TL; 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.
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's other proposed sessions for 2026
A Whirlwind Tour of the Fabric Capacity Metrics App - 2026
Copilot in Fabric - Explained for the Administrator! - 2026
Deep Dive into Microsoft Fabric Capacities: Fundamentals, Concepts, and Advanced Strategies - 2026
Demystifying the on-premises data gateway (for Power BI Semantic Models) - 2026
End-to-end Monitoring for Microsoft Fabric - 2026
Exploring permission boundaries in Microsoft Fabric - 2026
Fabric Capacities, beyond the obvious - 2026
Panel Debate: Real-World Microsoft Fabric Administration - Lessons from the Trenches - 2026
Slide Karaoke - Ultimate Showdown! - 2026
Star Schema ALL the things! But why? - 2026
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.