Forum Discussion
Solved
Data refresh via Power automate
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? Tha...
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.
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.
Can you tell me if there are frequent refereshes (like every minute) when updating the data using power automate does it cause any potential risk to the excel file on share point?
Not clear what you mean. Power BI cannot write to a data source like Excel.