Forum Discussion
Daily refresh times
Hi Anonymous ,
1. You can view Power bi Premium Capacity Metrics to view the number of refreshes in a day's time period. By viewing the length of the bar graph, you can determine which time period has more refresh times and which time period has less refresh times. Then you can manually schedule the refresh time by yourself (accurately set refresh in a certain time period of the day), so that you can balance it
2. Try to refresh the report when no one is using the report, such as in the early morning, because the report will also occupy memory when it is interacting.
About Power bi Premium Capacity Metrics and How capacities function, you can check the following link:
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-metrics-app
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
For automatic daily refresh, you have to set the time compulsorily.
The best way in my opinion would be to set the refresh daily after ETL load completes. It would be best if this ETL load time and subsequent Power BI dataset refresh times are in non-business hours.
Let's say your ETL load starts at 4:00 AM EST and completes by 4:40AM EST, then you can keep your Power BI refresh at 5:00AM EST.
You can also schedule the data refreshes after every 2 hours or so with 8 scheduled refreshes permitted with PRO License.
 |
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Hi, in the dataset settings > scheduled refresh, we are able to set daily refresh without specifying a time. Please see screenshot showing refresh settings (note no time specified) and refresh history (showing daily refreshes soon after midnight).
Anonymous ,
That's indirectly an automatic refresh for 12:00AM.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedInThe question is then, if a lot of datasets are set to daily without a specified time, will the service 'queue' them so they run until all are complete, even if it takes several hours?
Or, will it try to run them all at midnight, and if there is not sufficient refresh duration in that half hour slot, fail the refresh?
I am hoping that the former is correct!