Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)

Hi,   I'm really struggling to understand the error I'm having and I really hope someone can help me.   In Desktop I'm using an ODBC Connection to access a number of different data sources. One o...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi rocky09 ,

     

    I had a similar report set up on the Power BI Service that failed to refresh but provided me with a more detailed error. It turns out one of the fields contains string values when the ODBC connection was expecting date. When I checked the set up for the original data source the field in question was shown as a string so I'm not sure where the change occured.

     

    Luckily, in this instance, I think I'll be able to omit the field from the report as I don't think it's entirely necessary. Hopefully that will negate the issue.


    Thanks,

    MarkJames

Aberg8's avatar
Aberg8
New Member
2 years ago

I recieved this error because a field type in a SQL table was changed.  PowerBI was consuming a view that contained that field, and the view retained the incorrect field type.  I scripted the view to alter it, didn't make any changes, and run the "altered" unaltered sql.  The new version of the view had the correct datatype and PowerBI digested it with no issues..

Related content