Power Automate BI Refresh running into Throttling Issue

[Anonymous]

I built a flow to refresh my Power BI data sets in Power Automate. 

It ran flawlessly the first time but, on each subsequent run, it failed due to the aforementioned "throttling" issue. It tells me that I'm hitting an action limit but I don't know what that means or how to circumvent it moving forward.

[AlexisOlson · Accepted solution]

I'm pretty sure this is working as Microsoft intends. If you look at the documentation, you'll see

you can configure up to eight daily time slots if your dataset is on shared capacity, or 48 time slots on Power BI Premium.

They provide some additional clarification as follows:

It's also important to call out that the shared-capacity limitation for daily refreshes applies to both scheduled refreshes and API refreshes combined. [...] Also note tha datasets on a Premium capacity don't impose limitations for API refreshes.

Power Automate is an API refresh, so you'll get throttled unless you have a premium capacity. You can't cleverly circumvent intentional licensing limitations by using Power Automate instead of scheduling the refresh in the Power BI Service directly.