Forum Discussion
Solved
OLE DB or ODBC error DISP_E_TYPEMISMATCH
Hi All, this error shows up when I try to refresh data. The data source is a local csv : Config: windows 10 thanks for helping :) Adrien
The type mismatch is probably happening because you're doing some conversion from the orginial data types - go into the query editor and remove any type conversions and see if that works.
In my case, a column in Excel had a mix of numbers and blank values, i.e. "". The "" in Excel created empty strings, which PBI couldn't handle along with numbers
I have the same issue - what did you do to resolve this?
In Excel, I repalced the "" with "NA". Then in PBI, replace the "NA" with null.
