Forum Discussion

bansikpopat's avatar
bansikpopat
Frequent Visitor
3 years ago
Solved

Error due to auto data type change

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 ty...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.           

bansikpopat's avatar
bansikpopat
Frequent Visitor
3 years ago

Hi Anonymous , 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.