Question

You are cleaning a sales table in Power Query. After setting the 'UnitPrice' column to a Decimal Number type, the Column Quality pane shows 3% Error and 0% Empty. You need to investigate exactly which source values could not be converted before deciding how to handle them. What should you do first?

Accepted Answer

Right-click the error percentage in the Column Quality pane and select 'Keep Errors' to isolate the affected rows for inspection

Answer

Apply 'Remove Errors' on the UnitPrice column so the report can refresh without failure

Answer

Change the UnitPrice column type to Text so the values no longer generate conversion errors

Answer

Replace the error values with 0 using 'Replace Errors' before reviewing them