Estimating Capacity Units

[JoMing]

Just wondering exactly what we need to estimate how many Capacity Units (CU's) and how much storage we'll need in Fabric? We're looking at bringing data in from 7 different systems and using Power BI as the surfacing tool to create reports across the different data tables. We'd be bringing in data from these systems at least daily.

I have no idea if this will be 4 CU's or 64 CU's, which is the difference between $600/month and $9,000/month.

What data do I need to work this out?

[Mohan_Fab · Accepted solution]

Hi @JoMing ,

You can use Fabric Trial capacity to https://learn.microsoft.com/en-us/fabric/get-started/fabric-trial access to the Fabric product workloads and the resources to create and host Fabric items. The Fabric trial lasts for 60 days unless canceled sooner. Also, Use the capacity metrics app to review your usage and adjust your capacity size accordingly

Capacity Info: https://learn.microsoft.com/en-us/fabric/enterprise/plan-capacity?form=MG0AV3

Considerations: The amount of data you're bringing in from the 7 different systems daily and no. of queries execution.

[Mohan_Fab · Accepted solution]

Hi @JoMing ,

You can use Fabric Trial capacity to https://learn.microsoft.com/en-us/fabric/get-started/fabric-trial access to the Fabric product workloads and the resources to create and host Fabric items. The Fabric trial lasts for 60 days unless canceled sooner. Also, Use the capacity metrics app to review your usage and adjust your capacity size accordingly

Capacity Info: https://learn.microsoft.com/en-us/fabric/enterprise/plan-capacity?form=MG0AV3

Considerations: The amount of data you're bringing in from the 7 different systems daily and no. of queries execution.

[Mohan_Fab]

Hi @JoMing , You can use Fabric Trial capacity to access your workload and predict the capacity. Please refer the details here  https://learn.microsoft.com/en-us/fabric/get-started/fabric-trial. Use the capacity metrics app to review your usage and adjust your capacity size accordingly.

NOTE: The Fabric trial lasts for 60 days unless canceled sooner.

Fabric Capacity Details: https://learn.microsoft.com/en-us/fabric/enterprise/plan-capacity?form=MG0A...

Considerations: Try to calculate the amount of data you're bringing in from the 7 different systems daily and the number of queries.

[Anonymous]

Hi @JoMing,

Perhaps you can use 'pay as you go' mode and it will scala to the corresponding level sku based on your usages.

Microsoft Fabric - Pricing | Microsoft Azure

Save costs with Microsoft Fabric Capacity reservations - Microsoft Cost Management | Microsoft Learn

Regards,

Xiaoxin Sheng

[frithjof_v · Accepted solution]

"it will scala to the corresponding level sku based on your usages."

I don't think that's how it works.

For Fabric SKUs (F SKUs) I think you will need to monitor the utilization and then upgrade your capacity if you want to.

It doesn't automatically scale.

As mentioned by @Mohan_Fab I would use a free trial capacity (which is quite similar to F64) and the Fabric capacity metrics app to check how much resources your workloads are using.

There is also a private preview for an F SKU calculator, but I would definitely do some testing on a trial capacity as well. I think that will provide many valuable practical insights that the calculator cannot provide.

https://blog.fabric.microsoft.com/en-us/blog/announcing-the-private-preview-of-the-microsoft-fabric-...