Forum Discussion

davidz106's avatar
davidz106
Icon for Helper III rankHelper III
2 years ago
Solved

Scheduled 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. ...
Need Help
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    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~

     

     

     

     

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

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~