Power BI - Custom Query Load Order

To enroll in my introductory or advanced Power BI courses:

[analistax]

In my Excel time, I always knew I didn't know it, because I always discovered something fascinating that opened a new world for me. This video was the same thing for me as power BI. I've been on the forums for days now and I haven't been able to resolve it. I ended up finding this function and I entered your video to see about it, because I saw that it would be the solution to my problem. But the solution was just to disable the parallel loading of the tables. I didn't know this parameterization. Thank you very much!

[spilledgraphics]

7, 232 lucky viewers who have seen this video, voilà Parker.

[xander]

This is great! However is it possible to do it without using a time delay, but rather waiting on a specific refresh to complete before starting?
I have several API pulls that take as short as few seconds to refresh, to as long as 30+ seconds. The pull that takes the longest will only continue to get longer as the data grows. So I am hoping to set a specific sequence that a refresh will follow. TIA

[jansiebrecht]

I am skeptical, this actually has an influence on the actual load order.
When the engine executes the code of your query and hits the Invokeafter function, the query is already running. It simply waits the specified amount of time to connect to the data source. Try it out with 3 queries starting after 5, 10 and 15sec. Write down the order they ran in. Then rotate the order of the delay and run again. compare the run order with previous results and you will see.
Power BI analyzes which query it requires first and execute them accordingly.
If they are all of equal priority, it will execute in some other way.
Was too good to be true... ;-)

[akpokemon]

what? You can only specify a time delay? You can't tell it to run once another has finished? Inability to do this is leading to refresh errors that have put a halt to our entire environment

[wfnjock]

You are only delaying the evaluation. it is not possible to delay the actual API call. I just tested this and it did not work. All the calls were ultimately done at the same time.

[giftfurnito]

Hi, by using power query, how can extract order tables from my WordPress website, has credentials?plz help me

[o.yetunde]

Hi Parker, does this enhance performance in any way?

[DmitryRee]

Parker, what could be a use case for a custom load?