Regularly I come across the following problem. A model is based on Get Data from a folder, monthly files are added to the folder. After a while the customer decides to add a few columns to the source data, January and February were the same, then in March a new column has been added and the query breaks.
Today I solve this by adding a similarly named column in the first file used to create the model.
I am sure there must be a more sophisticated way of doing this.
Appreciate your comments.