Nov 23 2018 08:07 AM
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.
Nov 23 2018 08:30 AM
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.
Nov 27 2018 10:01 AM
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.
Nov 27 2018 10:06 AM
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.
Nov 27 2018 11:58 AM
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
Nov 27 2018 12:34 PM
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.