Getting data type format error while loading Mysql database table to power bi desktop

[Amar-Agnihotri]

I have an azure adf pipeline that copy tables from on premises Mysql db to blob in .csv files and then i am pulling those .csv files in power bi desktop.  Now when i amtrying to filter the rows i am getting datatype format error in rows where datatype is int in MySql. See this  -

These are the datatype in MySQl table -

I am having 30 + columns . How to get resolve this issue ? Please suggest. 

[Anonymous]

Hi @Amar-Agnihotri ,

Does @Vijay_A_Verma 's suggestion help you resolve the issue? If it does, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Vijay_A_Verma]

Select this column - Home - Keep rows - Errors - Then you will find rows with errors.

If it doesn't show errors still - 

At the bottom of the screen, you see column profiling based on 1000 rows. Click that and change it to all rows.

Now, in the column quality, it should say how many errors.

Now select this column - Home - Keep rows - Errors - Then you will find rows with errors.