Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

i was doing some transformation in power query, but when i close and apply, i get this error. its my first time seeing this. i tried looking at similar questions but i still don't get how to solve this.

 

I've went into applied steps -> Changed Type, and used the Detect Data Type. Is this not good enough?

EDIT 2

it seems that this error happens when i filter a column. If i don't do this step everythings ok


any help much appreciated! let me know if you need more info.

Need Help

1 Reply

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    2 years ago

    Anonymous 

     

    Check your column has values other than numbers that's why you are getting this error. I did face this kind of error while working with the client's data. 

     

    DataFormat error. What I do is try to find out the column having the error then change the data type. If I get an error similar to yours then I change the data type to text. 

     

    Did I help? If yest, hit 👍 and accept my solution as answer.