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 ,
You set it to the same time, theoretically it will be executed in parallel at the same time, but each report will have a certain time delay according to the current network status and the size of the data set, such as 15 minutes to 1 hour.
If you perform parallel execution at the same time, it depends on whether your capacity is sufficient. When the report is refreshed at the same time, the model used for refreshing will be loaded. Once there are a lot of models in the memory, the memory will be full, so that the model generated by the subsequent refresh operation will not be loaded and enter the queued state. The report will be slow to load or even fail
You can check the refresh time by viewing the Refresh Summary and metric usage app to make reasonable allocations. Try to choose free time for refreshing, and divide the refreshing time that is concentrated and refreshing together, so as to avoid too many people to occupy resources and cause queuing
For related content, you can check this link:
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-what-is
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.
Thanks. Regarding your comment "Once there are a lot of models in the memory, the memory will be full, so that the model generated by the subsequent refresh operation will not be loaded and enter the queued state. The report will be slow to load or even fail"
How can we ensure that queued refreshes do not fail?
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.