Frank Rowan
New Member
My workstation has MS-Office Pro+ 2010 installed. I have some Excel books that that have multiple Power Queries. One of the Power Queries sources data from an enterprise SQL-Server database source then populates an Excel table on a worksheet. This query typically has a refresh time of 3-4 minutes.
I have a second Power Query that uses the table built by the first query as its source. It will refresh within 10 seconds.
When I open the Excel book, navigate to the Data Ribbon, then click Refresh All, both queries refresh simultaneously. The second query extracts from the first table far before that source table is refreshed by the first query. The second query is then sourcing obsolete data.
Question: Does anyone have a solution to automate Power Query execution order where child queries wait until it's parent query is completed?
I have a second Power Query that uses the table built by the first query as its source. It will refresh within 10 seconds.
When I open the Excel book, navigate to the Data Ribbon, then click Refresh All, both queries refresh simultaneously. The second query extracts from the first table far before that source table is refreshed by the first query. The second query is then sourcing obsolete data.
Question: Does anyone have a solution to automate Power Query execution order where child queries wait until it's parent query is completed?