Question

You import a CSV of daily transactions into Power BI Desktop. During refresh, the query fails because a few rows contain the text "N/A" in the numeric Amount column, causing type-conversion errors. The business confirms these rows are invalid test entries that should not appear in reports, and future files may contain similar bad rows. Which Power Query approach ensures refreshes succeed and permanently excludes only the offending rows?

Accepted Answer

After setting the Amount column to a decimal type, use Remove Errors on that column so rows that fail conversion are dropped automatically on every refresh.

Answer

Set the Amount column to Text type so the "N/A" values no longer cause conversion errors, then load the table as-is.

Answer

Use Replace Errors on the Amount column to substitute 0 for any error value so the rows remain in the model.

Answer

Disable the refresh error checking in the query's properties so the transaction load ignores all conversion failures.