Revision history [back]

There are several ways to deal with Expression.Error related to a column in Power Query:

1. Check for null values: The error may occur if the column contains null values. Check for and remove any null values in the column.

2. Check for missing or malformed data: The error may occur if the column contains missing or malformed data. Check the data source to ensure that the data is correct and complete.

3. Try using a different function or transformation: The error may occur if the function or transformation used in the column is not compatible with the data type or format. Try using a different function or transformation.

4. Reformat the column: The error may occur if the column has an incorrect data type or format. Reformat the column to the correct data type or format.

5. Use the error handler: Power Query has an error handler that allows you to ignore errors and continue with processing. Use the error handler to skip over the column or rows causing the error.