Forum Discussion
modifying data in queries
I created a multiple queries from Table
the issue is if I change any data in the Query it disappears when I refresh . How can change the data in the original table from the Query View.
What do you mean under query view? If resulting Power Query table which is loaded into the table in Excel sheet - when that's one way transformation. Any change in worksheet table will be overwritten by query result.
I have a worksheet with data
I went to Data/New Query From Table /made my changes /hit Close and Load
I now have a new worksheet with the new customisation
If I change anything in this new worksheet like add or change a number. every time I hit refresh it will replace my changes with the data data from the Source.
Yes, that's by design. Query takes your data, makes transformations and writes resulting table into the Excel sheet. Whatever you change in that table will be overwritten with next refresh cycle.
