Error due to auto data type change

[bansikpopat]

I have data in excel and imported the data in powerBI. However, when I refresh the data, I see error in loading the data. Below is the screenshot of my error. 

It is the error of data type mismatch and I want to debug the error. How do I identify which column to look at? I have 300+ columns and 1000+ rows. 

Is there an easy way to figure out which column has the error? 

[bansikpopat]

Hi @v-stephen-msft , thank you for your response.

Why do I need to remove the step changed type in applied steps? After importing the data, I am manually changing data type for some of the columns. If I remove it, my manipulations will also be deleted. 

Meanwhile, I will also disable the type detection feature and see if it helps me. 

[v-stephen-msft · Accepted solution]

Hi @bansikpopat ,

First way is to remove the step named "Changed Type" under applied steps.

Second way is to disable the type detection option under data load.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.