Forum Discussion
power BI Services
Hi
we have a schedule refresh for 10 reports at same time daily
this 10 reports are refreshing at 6am UTC so this reports are getting fail because most of the reports pointing to one datasource and due to heavy load. forcefully it is stoping the other refresh. when we try to refresh one by one manually their is no issue
as per client requirment we should not change the time
is their any alternate solution that reports can refresh one by one automatically without changing any schedule refresh time/ in a queue process
5 Replies
- lbendlin
Super User
How long does each refresh usually take when it is running by itself?
Power Query has a Function.InvokeAfter function that allows you to specify delays.
Note: The Power BI service usually staggers the requests anyway, so your delays need to be substantial (five minutes, for example) to make sense.
Also consider ditching the scheduled refresh and running API refreshes instead.
- djurecic
What is the datasource? Are you able to increase the computing power of the datasource? Are you able to make a copy of the data in the datasource and use that for some or all of the report refreshes?
- lbendlin
Unless you substantially improve the performance and concurrency level of your data source this will not work.
