Forum Discussion
Power Query does not recognize subsequently added columns in source file
Your "Removed Other Columns" step will always remove newly added columns. You either need to edit that step, or remove it and instead select the columns you do not want and remove those. Then newly added columns will always come in.
Hello Fowmy
yes, that works perfectly fine. I tried it with Sharepoint Folder as well as Excel offline source and there is no problem with the added columns.
Probably I have to change some of the applied steps (refer to the picture). As you can see the Sharepoint has lots of different files. I filtered for .xlsm as it is the only file I want to use. After that I removed top rows. But the last 3 columns from source data are missing.
Your "Removed Other Columns" step will always remove newly added columns. You either need to edit that step, or remove it and instead select the columns you do not want and remove those. Then newly added columns will always come in.