I am trying to automate a scale up and scale down of one of our embedded capacities from A3 to A4 in order to accomodate a report refresh that currently exceeds available memory during the refresh. So far all solutions I've seen involve scaling based on the CPU utilization, which is not anywhere close to being significant enough on our capacity to be able to reliably use. 99% of the time our CPU and memory utilization is low enough to be A3 but with the memory spike during report refreshes in the Power BI service we are forced to use A4. Long term we are optimizing our source tables and Power Query but we're looking for a quick temporary solution to cut down on cost.
What I'd like to do is be on A3 for most of the time and scale up to A4 shortly before we have the refresh scheduled in Power BI. After 30 minutes to an hour I'd like to scale back down to A3 once the report has completely refreshed.
This seems to be close to what I want as far as the powershell goes but I don't necessarily need it to be zero downtime since this will be happening early in the morning.
This is also similar to what I'm wanting to do but is based on Azure Alerts related to the cpu usage.
Has anyone been able to scale using a Powershell runbook scheduled in Azure Automation Accounts?
