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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors