Forum Discussion

StrPod's avatar
StrPod
Frequent Visitor
2 years ago

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 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.. 

Need Help

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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!