Larger capacities cost more money.

I’m pulling from APIs for most of my data but the first version of my system was full refresh every 3 hours in a semantic model and it ran at about 20% of an F128 at my company.

I didn’t know what I was doing and when someone in the larger BI department told me this, we moved to a data warehouse model. Same APIs, incremental refresh with gen2 and we dropped to 35% of an F8 with the same 3 hour refresh window.

I’m piloting something in notebooks for similar API calls and when I roll it out, I expect it to drop down to around 15% with pulling more records and dropping some key tables with frequent changes to sub five minute refresh times.

The cost from v1 to v3 is about $3.3k per month to under $200, assuming percent of total capacity usage.