Data refresh via Power automate

[NewbieJono]

Hello, i have power BI pro.

i have set power automate to refresh the dataset once my sharepoint file is updated.

is this also limited to 8 times per day. when does the 8 limit reset? 

Thanks all

[lbendlin · Accepted solution]

Existing limits on refreshes apply when running the refresh dataset action in Microsoft Flow.  For datasets in shared capacity used by Power BI Pro, your refresh action is limited to eight refreshes per day (including refreshes executed via Scheduled Refresh). In Premium capacities, there is not limitation on the number of refreshes per day, although you are limited by the available resources in your capacity.  If there are not sufficient resources, the refresh execution may be throttled until the load is reduced. If this throttling exceeds 1 hour, the refresh will fail.

The Power BI Service operates on UTC days.

[New_Folder]

Can you confirm that the Premium refresh limit is unlimited? Based on their site its 48/day.  

https://powerbi.microsoft.com/en-us/pricing/

[lbendlin]

That's for scheduled refreshes (Every hour, top of hour and bottom of hour). Does not apply to API refreshes.

[New_Folder]

I have my datasource from smartsheet on a dumpsheet that receives random amount of data every 5-10 minutes.

What is the closest I can have for arealtime update on my Power BI DataSet and report. Im on the Pro license only.

[lbendlin]

the answer is still eight refreshes a day. If I were you I would initiate the refreshes via API at a moment of your choosing, rather than on a schedule.