Forum Discussion
Power Query - Add Data to Loaded Table.
Hello. This might be a bit of a newbie question. Hopefully there's an easy answer: I'm loading data into Excel from an external data source using Power Query. In the resultant table in Excel,...
That's not obvious task, column added to the table returned by Power Query is not synced with it on refresh. The workaround is
- you need to have some unique ID in the table returned by Power Query.
- add manually column with comments
- without refresh query result (actually you query result of query), but that shall be done as separate query, as another step in initial one
- merge first table with this one on ID, do cosmetic and return result to Excel sheet on the same place
I lost the link on post(s) with step by step instruction on how to do that, try to google for it.