Forum Discussion

keow81's avatar
keow81
New Member
3 years ago

Can a query LOAD TO its source?

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 tha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.