The Table.TransformColumnTypes
function in M throws an error when you try to transform the data type of a column that does not exist. As of March 2020, there is no missingField parameter that can address this issue, in contrast to some other Table functions, like Table.RemoveColumns
, which I blogged about before. This blog post shows how to imitate the behavior of the MissingField.Ignore
argument in Table.TransformColumnTypes
.
Continue reading “Safely transforming column types in Power Query”