Last week I shared my understanding of how capacity works in Microsoft Fabric. I just hit publish when I got a message that I exceeded my Fabric capacity (again).
Time to open the Fabrics Metrics dashboard I introduced in my last post about Fabric and see who is the culprit:
I opened the Compute tab and hovered over the top item in the list.
Turns out that Copilot is eating up a lot of my capacity. Whoops!
I decided to disable copilot for this data warehouse. Therefore, I opened up a query in the data warehouse and clicked on the Copilot completions item at the bottom of the screen:
This opens the configuration settings for my data warehouse where I can disable the completions:
If you want to disable Copilot completely, you can do that at the tenant level:
Remark: If you are still confused on how Fabric capacity exactly works, I found this great post by Tom Keim where he compares CU usage to watts:
Just like electricity, where we’re billed by kilowatt-hours (kWh), CU in Fabric represents a rate of consumption.
More information
Understanding Microsoft Fabric Capacity and Throttling–A first attempt
Help! My Fabric Capacity is at 100% - What Can I Do?
Enable Copilot in Fabric - Microsoft Fabric | Microsoft Learn