Forum Discussion
Referencing Multiple Queries
Hi ChrisR22 ,
When your data source data is updated, your append query is also updated when refreshed, and you don't need to appear to write a new append query.
Append queries - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
123abc is this assumption correct:
I append three queries together. The underlying data source (excel file) for any of those original queries is updated. When I click 'Refresh Preview' in Power Query Editor, these updates would flow through to not only the original query, but to the appended (aggregated) query, as well as any other query that this query was appeneded or merged with.
Is that correct?
If not, I am just looking for a way for those updates to flow through to an aggregated query, so that I don't have to create a new aggregate each time one of the queries is updated.
Hi ChrisR22 ,
When your data source data is updated, your append query is also updated when refreshed, and you don't need to appear to write a new append query.
Append queries - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.