Power QueryExercises

Schema drift

Changes to a source's columns over time, such as new, renamed or removed columns, which brittle queries don't handle.

Hard-coded column lists in Changed Type, rename and select steps are the usual casualties. Rule-based steps such as Table.TransformColumnNames, Unpivot Other Columns and MissingField options keep working when columns change, and validation steps can make an unexpected change fail loudly.

In the Power Query editor

Usually discovered as "The column … of the table wasn't found" on refresh, at the Changed Type step.

Learn more

Practise it

Related terms