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

martaTr's avatar
martaTr
Frequent Visitor
2 years ago

why power bi cannot indicate where is a problem? i have 40 columns 😞 how can i check them one by one without loosing hours on that , that's crazy

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Agreed. I usually go into each datasource and make the primary and foreign keys all the same datatype, and that helps. PowerBI evidently remembers what the datatypes are for the rows of data that are appended, and sometimes, changing the datatype after you append doesn't change all the datatypes.

Related content