Help with automating append in power query

[StrPod]

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 appended to query2 is query1.

I know query2' initial filtered data before the append will update because it is a reference of query1. But will the appended data also continuously update each time a new data is added and quey1 is refreshed?

Goal is to do a comparison in pivot table of original data "query1" and filtered data "query2". Both have have duplicate data so it's not possible to do one to many. I can do a bridge table, but that would mean adding a additional query for each field I want to use in the pivotTable..

The only reason I am creating a reference is because I don't want to pull twice from the source which is the case if I were to create query2 as duplicate instead.. 

[BA_Pete]

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

[v-jingzhan-msft]

Hi @StrPod 

For the question "But will the appended data also continuously update each time a new data is added and quey1 is refreshed?", the answer is Yes. 

In every refresh, all queries will be refreshed. Since query2 is a reference of query1, you will find its data updated after a refresh completes. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!