How to manage the order of query execution?

[pmurz]

Is there a way to force Power BI to execute my queries in a known or preferred order?   
I have one model with well structured queries which sequentially build out a data model from a large JSON file of activities.

If I manually step through the queries in the logical order, the total time is a couple of minutes.   If I try refresh from the Desktop, it automatically tries queries out of that order and takes an exceptionally long time and often gives up. 

Any advice is welcomed.  

[pmurz]

@Greg_Deckler thank you for the advice.  Turning off the Parallel Loading did the trick.  It takes longer to execute, but never fails. 

[Greg_Deckler · Accepted solution]

@pmurz First, I would make sure that Parallel loading of queries is disabled. That is under the Report settings, Data load in File | Options and settings | Options.

Second, take a look if you can create a controller query for some of your queries. In other words, disable load on your base queries and then create a query that runs those other queries sequentially within it to create a table.

[PierreL69]

Hi  I am also interested in your query controller could you please elaborate ? thanks

[Anonymous]

Thanks for Greg,

Please could you elabrate on how to create a controller query for other querirs in sequence in Power Query and Power BI?