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.
I apologize for the confusion. It seems there was a misunderstanding. The "Enable Load" option is not relevant to Power Query Editor in Excel. Instead, you should configure data refresh settings in Power Query using the Power Pivot or Power BI tools. In Power Query Editor within Excel, there isn't a direct option to schedule data refresh.
To achieve automatic data refresh in Excel, you'll need to use the Power Pivot and Power Query features within Excel or consider using Power BI Desktop for more advanced data modeling and transformation. Here's a high-level overview of the process using Power Pivot in Excel:
Load your data into the Power Pivot model: In Power Query Editor, load your data into the Power Pivot model by selecting "Close & Load To" and choosing "Add this data to the Data Model."
Create relationships: If your data sources have common fields, you can establish relationships between tables in the Power Pivot model.
Configure data refresh: In Excel, go to the "Data" tab and click on "Queries & Connections." Then, right-click on your data source and select "Properties." In the "Connection Properties" window, you can configure the data refresh settings by clicking the "Usage" tab.
Schedule data refresh: If you want to schedule data refresh, you will typically need to use the Power BI Gateway (if your data is not local) and Power BI Services (if you want to refresh data in a shared environment).
The exact steps for configuring data refresh may vary depending on your specific version of Excel and the version of Power Pivot available to you. It's essential to consult the documentation and resources specific to your environment and Excel version for detailed instructions.
If you're working with Power BI Desktop, the process is similar, and you can schedule data refresh more easily from within the Power BI Service.
In summary, to schedule data refresh in Excel, you should leverage the Power Pivot, Power Query, and related features, and the exact steps may vary based on your Excel version and environment.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
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.