Question

You import a CSV file of product records into Power Query. A column named 'ProductCode' contains mostly numeric values in the first several hundred rows, but later rows include codes like 'X1050' and 'AB22'. Power Query automatically applied a Whole Number data type, and after loading you notice many ProductCode values appear as errors. What is the best way to prevent these import errors?

Accepted Answer

Remove the automatically added 'Changed Type' step and set the ProductCode column data type to Text

Answer

Use Replace Errors to substitute 0 for every error value in the ProductCode column

Answer

Increase the column profiling sample so type detection scans the entire dataset

Answer

Filter out the rows containing alphanumeric codes before the type change step