Forum Discussion
New Excel file in folder with new column not importing (cannot change the number of columns in code)
I have loaded data into power query from a folder that has multiple excel files. I have recently updated the last excel file with a new column. The new column does not add into power query. I have lo...
Does the colum appear further up in the query steps?
I had a similar issue when using a Table.SelectColumns so it didn't select my new column and replaced it with a Table.RemoveColumns
= Table.SelectColumns(#"Expanded est-pack",{"ItemDesc", "CustCode", "CustItemRef", "MasterEstimateCode", "InventoryQty", "PltQty"})
= Table.RemoveColumns(#"Expanded est-pack",{"ItemCode"})
Although on the face of it the 2 examples above look to give the same results the second will let you keep the new columns added!
Hope that helps.