Forum Discussion
Helper IIIScheduled refresh periods
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?
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~
1 Reply
- xifeng_L
Super User
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~