Dyota's blog

Power Query: MissingField

This is the a very common source of errors, especially in the very common situation where the source data is taken from an Excel file, and somebody changes the column order, or renames a column, or deletes a column.

These functions have a MissingField parameter (which takes a enum MissingField.Type), where you can specify what the function should do in the event it fails to find a field.

#powerquery