Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
StrPod
Frequent Visitor

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

2 REPLIES 2
BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




v-jingzhan-msft
Community Support
Community Support

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!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors