Data Type mismatch error

[Anonymous]

There are 167 columns in my report.
Detected Type mismatches error in Power Query.
But I couldn't find out which column is having an error.
I have tried using Column Quality but have not been able to find out an error.

[danextian · Accepted solution]

Hi @Anonymous 

As per documentation "By default, Power Query will perform this data profiling over the first 1,000 rows of your data. To have it operate over the entire dataset, check the lower-left corner of your editor window to change how column profiling is performed."

Power BI automatically detects the column types based on the first 1000 rows. If Power BI sees just numbers in the first 1000 rows, that column will be detected as type number which may not be the case. The error is usually on columns with data type date, datetime or numbers.