Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
58
Views
Topic starter
Hello.
I extract a DB in order to work with and need to review and change some values in some columns before plotting anything.
Is there a way to avoid overwriting the data every time I refresh the data?
I attached the DB (csv file), the excel that extract it and the question in column I.
Thanks and merry Christmas!
B
Posted : 27/12/2021 1:37 pm
Hi Bruno,
There's no way to refresh the data and not have it overwrite the previous query results. If you want to keep a copy of the data, then you could copy and paste as values to another table in the file or in a separate file, that way the data is no longer connected to the query.
Mynda
Posted : 27/12/2021 9:28 pm
