Power Query - Get Data from Folder - source files structure changed RRS feed

  • Question

  • Hi GUYS,
    I am loading from folder "Get Data" -> "From folder" several .csv files. Their structure has changed last week with new columns (from 84 columns to 115 columns) The new columns are located from column A onward so it messes up my query steps and calculations. I did a refresh but for some reason it does not load all the 115 columns, only 84 (all the new ones + the rest to 84 columns from the old ones). Any advice how to load all columns 115 without redoing all my query steps ?

    Monday, January 14, 2019 6:49 PM