Forum Discussion
Advocate IBillin an Event steram based on cu consumption
How to calculate the cost for an event steram?
Below is the 14 days statts from Fabric Capacity metirc
The calculation I ended up is as below:
CU consumption over 14 days: 620572 cu seconds
- F128 = 128 CU capacity
- Hourly cost = 24.411 AUD/hour
- So, per-CU-hour cost = 24.411 ÷ 128 = 0.19071 AUD/CU-hour
Convert to CU-hours:
620,571.8508÷3600=172.38CU-hours
Total CU(s) = 620,571.8508 (CU-seconds)
Convert to CU-hours = 620,571.8508 ÷ 3600 = 172.38 CU-hours
Cost for the workload window: 172.38 CU-hours × 0.19071 AUD/CU-hour = 32.88 AUD
Normalize per day / month
Per day: 131000 seconds approximately 13.09 days
Per day: 32.88 ÷ 13.09 = 2.51 AUD/day
Per 30-day month:2.51 × 30 = 75.3 AUD/month
I am not sure the correctness of this calculation. I want to see the group view on this calculatuion and correct me if I am wrong in this calculation:
Hi KGU_16031986
Thank you for contacting the Microsoft Fabric Community Forum.Your calculation is correct, with just a minor adjustment to consider:
The conversion from CU-seconds to CU-hours and the application of the per-CU-hour rate are accurate. The total cost over 14 days is approximately AUD 32.9.
The only suggestion is to normalize by the full 14-day window rather than the “active duration” (13.09 days), since the CU-consumption metric already reflects active versus idle usage.
Per calendar day: 172.38 CU-h ÷ 14 = 12.31 CU-h/day
Daily cost: AUD 2.35/day
Estimated 30-day cost: ≈ AUD 70.4
If you prefer to use “active days” (13.09), your figures of AUD 2.51/day and AUD 75.3/month remain valid.
In summary, the total cost for the 14-day period (AUD 32.9) is correct. The difference in monthly projections depends on whether you use calendar days or active usage days for normalization.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
5 Replies
v-karpurapudCommunity Support
Hi KGU_16031986
Thank you for contacting the Microsoft Fabric Community Forum.Your calculation is correct, with just a minor adjustment to consider:
The conversion from CU-seconds to CU-hours and the application of the per-CU-hour rate are accurate. The total cost over 14 days is approximately AUD 32.9.
The only suggestion is to normalize by the full 14-day window rather than the “active duration” (13.09 days), since the CU-consumption metric already reflects active versus idle usage.
Per calendar day: 172.38 CU-h ÷ 14 = 12.31 CU-h/day
Daily cost: AUD 2.35/day
Estimated 30-day cost: ≈ AUD 70.4
If you prefer to use “active days” (13.09), your figures of AUD 2.51/day and AUD 75.3/month remain valid.
In summary, the total cost for the 14-day period (AUD 32.9) is correct. The difference in monthly projections depends on whether you use calendar days or active usage days for normalization.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.- v-karpurapud
Hi KGU_16031986
I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.
Thank You. - v-karpurapud
Hi KGU_16031986
We would like to confirm whether the issue has been resolved. If it is still outstanding, please share any additional information so we can assist you further.
Thank you.
- v-karpurapud
Hi KGU_16031986
We have not yet received a response regarding your query. Could you please confirm if your issue has been resolved? If not, kindly provide additional details so we can offer further assistance.
Thank you
frithjof_vCommunity Champion
I would perhaps multiply by 1.25.
Because, your capacity is likely not running at 100% on average - that would be risky due to throttling. Let's say your target average utilization of the capacity is 80%, so you have a safety buffer of 20% to avoid entering throttling.
In that case, I'd multiply the chargeback by 1.25 (100%/80%) so that everyone's contributing to paying for the safety buffer as well.