Forum Discussion

christeddy's avatar
christeddy
Regular Visitor
4 months ago
Solved

OLE DB or ODBC error

After data transformation, I get this error when trying to load the data. Power Query Keeps FIltering Rows Instead of Deleting them 
Need Help
  • parry2k's avatar
    parry2k
    4 months ago

    christeddy in this column (with the error), you are converting it to a number, whereas it clearly contains the text "A506401". Either fix the data at the source, or change the data type to text in the existing "change data type" step.

collinq's avatar
collinq
Super User
4 months ago

HI christeddy ,

I am not seeing an error message, can you try to put it in again?

christeddy's avatar
christeddy
Regular Visitor
4 months ago
Load
 
"Year 2009-2010
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number.. '."

Copied error.
  • collinq's avatar
    collinq
    Super User
    4 months ago

    Hey christeddy ,

    The "can't convert to Number" issue means that you have a column in a numeric data type but one of the fields is not actually a valid number.

     

    In Power Query find that column and find the errors and then fix them or the data tyhpe.

     

    WHile the error says that is numbers the name of the field indicates that it is a date field, is that right?  If it is a date field data type, then check for a bad or non-real date in that column.

    • christeddy's avatar
      christeddy
      Regular Visitor
      4 months ago

      I don't know how to find the columns with errors. Almost half a million records lol.