Can a query LOAD TO its source?

[keow81]

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

thank you!

Marco

[Anonymous]

Hi @keow81 ,

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

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.           

[ppm1]

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? 

Pat