Importing from CSV

[M036721]

Hi Guys

I have a monthly dashboard which is built by getting data with a CSV file  when i replace it with another similar file...refresh is failing saying few columns missings is there a way we can refresh a power bi dashboard even if the number of column reduces or added more?

[ppm1 · Accepted solution]

See which step in your query is producing the error. It is likely one specifically referencing one or more columns by name. Hopefully it is one of the functions that supports a MissingField.Ignore parameter.

Missing Field Ignore | How NOT to break your Queries 😎 | Power Query Magic - YouTube

Pat