Power BI Desktop automatic refresh queries one-by-one

I've researched this a ton but can't find the answer to these questions:

• When parallel loading is disabled, what determines the load order?
• Is it the order of the queries in the query list under Edit Queries?
• How do query dependencies come into play?
• Also, when parallel load is enabled, does the refresh give any priority to predecessors in the dependency network?

I THINK the load order is only based on the order of the query list when this parallel load is disabled. But, I am not sure how query dependencies play into that.

Besides this thread, here were a couple other links I found useful: 

https://community.powerbi.com/t5/Desktop/Query-Dependencies/td-p/28306 (Makes good points about how caching order effects what is "current" when the loads happen)

https://www.youtube.com/watch?v=YfdypVSYb9c  (Shows how to introduce delays to manually force the order)

In my situation I have a table which is a join of two predecessor tables. I have an index column which is created after a sort which is done after the join. If the refresh of this table hits the cached version of one or both of the predecessor tables then the index value will be incorrect. This creates some odd behavior in the report. It usually resolves itself with multiple refreshes but makes the data feel very unreliable. It would be great to get some more clarity on these questions!

Thank you Guavaq.  It makes it and no crash any more.

Hi GilbertQ 

Is there a way to do this in 'EXCEL' ? I could not find the 'Enable parallel loading of tables' in Excel ? 
I have certain number of tables which I want them to load in a particular order.

Example: I have two tables:

Table 1
Table 2

Now, I want the Table 2 to be loaded only after Table 1 is loaded completely (i.e it should not refreshed parallely)

Any help or workaround for this in 'EXCEL' would be appreciated.

Thank you !