Forum Discussion
Help with automating append in power query
How can I setup a dynamic append between query1 and query2 so that query2 updates automatically with query1's refresh? Note that query2 is a reference of query1 that has been filtered. And the data ...
Hi StrPod ,
You're not avoiding a second pull from the source by referencing Query1.
There are some edge cases where Power Query can/will cache query results to use them later but you should generally assume a source hit per query, regardless of whether they are duplicated/referenced etc.
Pete