Forum Discussion
hmokkapati
Helper II
Helper IIDelay Queries
Hello, I have a pbix where I have around 7 queries. Is there a way I can stop queries 2 to 7 to start processing unless i finish Query 1. I can use the Function.InvokeAfter(), but there is no way...
To my knowledge it is not possible to let one query start after another one has finished. As it is not possible to influence the order of queries. So the options you have are:
1) make the Function.InvokeAfter-time long enough plus some buffer
2) allocate your queries into 2 different folders and manually start the refresh of the 1st one and then start the refresh of the other ones manually again
3) Always refresh twice (this would only work if the data doesn't change in between)
hmokkapatiHelper II
Helper IIHello Imke,
As a second thought, even if we have queries in different folders and decide to refresh each folder separately how can I achieve the same once the file is published to the Online Service? Any pointers?
Thank You,
Harisha
ImkeF
Community Champion
Community ChampionSorry, no - this is not my field.