Forum Discussion

adrien5555's avatar
adrien5555
Icon for Helper II rankHelper II
10 years ago
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  
Need Help
  • austinsense's avatar
    austinsense
    10 years ago

    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.

joebobjohnson's avatar
joebobjohnson
New Member
3 years ago

I have the same issue - what did you do to resolve this?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

In Excel, I repalced the "" with "NA".  Then in PBI, replace the "NA" with null.