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

Power Query’s MissingField.Ignore

The video demonstrates how the optional MissingField.Ignore argument can prevent a Power Query query from failing when a column referenced in a later step is missing.

Using a simple four-column dataset, the presenter shows three examples:

• Removing columns: Pass MissingField.Ignore to Table.RemoveColumns so the query continues if a column to remove no longer exists.
• Renaming columns: Use the option with a renaming operation to avoid an error when the source column is missing.
• Reordering columns: Use it when reordering so the step can complete even if a specified column is absent.

The presenter describes these as the three uses they have found so far and does not claim the option applies to every Power Query operation.

Main speaker/source: Chandeep, from the Goodly channel.