Forum Discussion
** HELP ** Power Query and Manual Text Out of Sync after refresh
Hi All, I'm wondering if you can help. I have a Power Query which is pulling data from Smartsheets; however, when that data is put into Excel, we inserted a column (outside of the query) where we...
Power Query doesn't sync manually added column, by default it has no idea of it. Workaround is to query returned into the greed table, merge it with the source query and return result into the grid. All steps are to be in one query.
Google self-referencing query for more details.