Forum Discussion
OLE DB or ODBC error: type mismatch (exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
Hello,
I have a report that has been running just fine for the last few weeks. Nothing has changed about the report.
Upon attempting to refresh the data today - it does not work. If gives me this error:
OLE DB or ODBC error: type mismatch (exception from HRESULT: 0x80020005 (DISP_E_YTPEMISMATCH))
Any ideas about what is going on and how to address this?
Thanks,
24 Replies
Hi,
had this error a couple of times...was able to solve it everytime when I checked the source. In the last case my Excel table (which I feed manualy) produced a few empty rows at the end refering to no data...deleted them and everything was fine.
Hi,
Reason for this error is that the content of your data has changed.
It means for example that you have a text in a number formatted column.
For example :
* you have a column in your report who also only containes number values and your data type is also number.
When refreshing your data if this column now contains a text value, then you will receive this error.(This is the reason for mismatch)
#example;
row column a
1 10
2 22
3 35
4 Ranking
You can solve this with Power Query by sorting and deleting this unwanted rows and your report will refresh again.
Is this in the Service, Desktop or gateway?
Desktop.....
Can you please give us some information about your query and the failure? Sending a frown with traces would be very helpful.
(Just a guess, are you connecting to an Analysis Services Database?)
I was able to resolve this error, it turns out that when I was merging 2 Excel tables with same columns, the columns themselves didn't get the correct matching types. Once I changed the columns to match it worked properly.
