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.
How to write a Session Abstract, to get chosen to speak
Writing an abstract is hard, especially for a session you'll probably only be presenting a few months down the road. But have you considered consciously on the words you're writing in there, and what kind of expectations they set to other parties?
Having a balanced abstract will help set the expectations for your presentation correctly, before it actually starts. Clearly outlining the goals helps all parties involved, most importantly yourself!
Troubleshooting Power BI Reports
Starting off with the new Performance Analyzer Pane, we'll demonstrate how you can pinpoint bottlenecks in your report, and take actions on these insights.
With the myriad of root causes that are out there, an elimination approach might suit us very well.
Some of the main causes will be explained, and we'll get you going on how you can fix it for yourselves.
Asking questions to get meaningful answers
Asking questions is a very powerful tool, but can be bothersome to wield. 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.
Power BI dataflows? Why you need to implement it!
During this session, the core concepts of Power BI Dataflows will be explained, and we'll discuss how Power BI Dataflows could alleviate some of the specific problems you might be experiencing in your current architecture.
Troubleshooting Power BI Report Performance
Starting off with the new Performance Analyzer Pane, we'll demonstrate how you can pinpoint bottlenecks in your Power BI reports, and take actions on these insights.