Hello,
I want to update a table 'Data_Table' based on data from a second source 'Platform_Data' (which is a query from a csv file).
I created a power query who's source is 'Data_Table', added some Replacer.ReplaceValue operations for some of the columns and now want to load the results back to the original table 'Data_Table', but Excel says "Query results cannot overlap a table or XML mapping. Please select another destination".
I don't want create a second, new table somewhere.
What am I doing wrong?
I want to update a table 'Data_Table' based on data from a second source 'Platform_Data' (which is a query from a csv file).
I created a power query who's source is 'Data_Table', added some Replacer.ReplaceValue operations for some of the columns and now want to load the results back to the original table 'Data_Table', but Excel says "Query results cannot overlap a table or XML mapping. Please select another destination".
I don't want create a second, new table somewhere.
What am I doing wrong?