Workload isolation in the Fabric cluster

[Timothy_VanBrus]

It would be nice to assign a percentage of the fabric capacity resources to specific workloads.

It could avoid that Power BI users are consuming all the resources, and that warehouse pipelines can not run because of lack of resources.

[Timothy_VanBrus]

💭 Imagine that you've developed some really nice TSQL transformations that fully cover the business requirements of your customer.

So you deploy your code to production, you schedule the pipelines to run during the night, and you're ready to receive the credits for all your hard work and sleepless nights 🙌

😱😵 The next day you wake-up and your mailbox is full with alerts, and business users who are unhappy because you didn't live up to their expectations...

⁉️ What happened? The Fabric capacity throttled because the resources where used for non-Data Warehouse workloads 🤌🤦‍♂️

[filipefumaux]

If I might add, not only isolation but management in general.

Some customers will have a procurement team that allowed only one CU for Fabric, which shall be managed and distributed across different teams/workloads.

Slicing this CU along will help to isolate and reserve as we used to have in Synapse

[oaladekomo]

Thanks for your suggestion. We hear this along with another need to limit consumption in a more granular way, typically at the workspace level. We’re not currently planning to provide workload level limits, but we are actively planning how to provide workspace level limits.