Forum Discussion
OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)
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
Advocate IHi All
I experienced the same error in the Desktop version, when changing the sources (excel file). The error occured due to a change in the excel file due to an update of the software that I extracted the data from.
Error message: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)
The issue arised due to incorrect type of some date columns.
To fix the issue, go into Power Query Editor and right click on each column. Go to: Change Type and check what type each column is in your table.
In my case the issue arised because I had some date columns that had to be changed to the type Date. When the date columns were updated the error disappeared.
Great! It worked out for me, but instead of date was with a numbers column, was appearing as string, changed it to whole number and worked.