This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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.
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
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.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |