Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number..

Hello,  I am getting an error message below in my Employee table, but I cannot find where the error is.  I'd greatly appreciate it if if anyone could let me konw the steps in finding the errors in p...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Anonymous ,

    Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

    Best Regards

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You need open the power query and check step by step. A column is giving an error after the type is changed to a number. All such column for which you have change type to number and at source it not number, they can give error.

 

Also, it can happen, that by default power query made it a number and you corrected it by making it text by adding a new step. But it need to corrected at very first step where power query made it a number

 

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs