Can a query LOAD TO its source?

Question

Hi Everone,I am setting up a file with 2 queries: 1 takes data from external CSV and has the transactions of the current month. The other query loads the historical data (defined table in excel that is therefore the source for this query), receives the data from the other query, recalculates the running total. What I would like to do now is to get this data back into the Historic Table, so in effect the query would amend its source table.I have to admit I am a newby, but the LOAD TO TABLE Options do no seem to allow it? What am I missing? also searched the Internet for some time but cannot find a solution&nbsp;thank you!Marco

ppm1 · Answer

You could probably do that with Power Automate (if the data are in an Excel table, not just a worksheet), but why not just store and combine all the csv files?&nbsp;&nbsp;Pat

anonymous · Answer

Hi&nbsp;keow81&nbsp;,
&nbsp;
The transformation in Power Query does not affect the data source. If you have some data transformation in Power Query and want to bring back the data source,&nbsp;you can export the query results to an Excel or CSV file, and then update the data source with the data in the Excel or CSV file.
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
&nbsp;

Forum Discussion

Can a query LOAD TO its source?

2 Replies

Related content

power query editor slow loading

Heartbeat Action Query Not Sent to Source

Data Source Error when loading into Power Query

Load multiple tables using query

Impossible to Load: Token Time Out in Power Query