Forum Discussion
modifying data in queries
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.
Is there a way to filter the original Data sheet based on the query sheet
So we can easy make corrections to the original data
That's what Power Query is for. If you create new query click on Edit or Transform (depends on version) button instead of Load. If existing query - Data->Queries and Connections->in the right pane double click on query name or use right click menu.
You'll be in Power Query editor after that to make the transformations.