Scheduled refresh periods

[davidz106]

My data source is an excel file on OneDrive. I have turned on the scheduled refresh however I can see only two options (weekly and daily). I choose daily and now report gets refreseh 1-time per day. I would like to have it refreshed each hour or at least 3 times per working hours. How to achive that?

[xifeng_L · Accepted solution]

Hi @davidz106 ,

You can add refresh time nodes below, you can add one time node per hour. However, need to note that PowerBI PRO licences are limited to eight refreshes per day and PowerBI Premium licences are limited to 48 refreshes per day.

Or use PowerAutomate's Scheduled Cloud Flow to perform a PowerBI report refresh, with hourly intervals supported, for example:

PowerAutomate's methods actually call the PowerBI REST API, which can only be refreshed eight times per day for PowerBI PRO licences and unlimited for PowerBI Premium.

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~