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.
This also worked for me. I had several date and number columns in string format. I changed the format and worked. Thanks!