Forum Discussion
Power Query - Column added in source
Hi, I am using Power Query to merge monthly files (extracted monthly from our costumer system) into a single table in Excel. This month a new column have been added in the extracted file, th...
The easiest way is to add one more column into sample file (very first one), just only header is enough. Or make not blank any cell in this column if you have no headers (zero or "").
And it's better to remove Change Type step in main query since it hardcodes column names.