I have two queries that load data from a table I've created from an external data source. I (naively, I think) assumed that on "Refresh All" the external data would load first, and the queries that use that data would load next; it does not appear that this is the case.
I suppose my question is: is there a way to ensure that my "dependent" queries are refreshed after the initial data is loaded from the external file?
Regards,
Craig
PS Mynda, your PowerQuery training videos are really, really good - I especially appreciate the short "technical bits", as one of them helped me to fix a query in the last few days that I wouldn't have been able to do otherwise.
Hi Craig,
Great to hear you're enjoying the course and finding it helpful!
In regards to your two queries, are these loading data from a Table in the worksheet that you created with another query, or are they directly connected to the query that gets the data from the external source? If the latter, then they should respect the dependencies. However, if you load the first query that gets the data from the external source into a Table in the worksheet, and then use that table in the other queries, then it won't always refresh in order.
Mynda
Thanks Mynda, that makes sense. The "order" of things is that the first table is populated from the external source, then the other two tables are populated using "subsets" of data from the first table. I realise that I didn't make that clear in my initial question; precision in language is important!
It looks as if I'll have to make sure to refresh the "master" query first, then I can do a "Refresh All" and it will all work :)!
Regards,
Craig
I'd be inclined to not load the first query's data to a table. Instead, link the other two queries directly to the first query. This will remove the need for a double refresh.
Alternatively, if you need the first query's data in a table, you can still load it to the table, but the other queries should link to the first query, not the first query's data in the table in the worksheet. This will also remove the need for a double refresh.
Hope that helps.
Mynda
