Well it seems there are two ways:
- using xmla endpoint, but not sure how that would work using azure somehow to automate this. In that case it doesn’t count the max amount of refreshes per day.
- flow it says it should be possible, but I read very conflicting things where in some places it says up to 48 times in premium and sometimes it says based on the capacity …
So, I’ll be trying this over the weekend using flow and try it 50 times … Let you know how that turns out (then at least we know what happens).