Forum Discussion

adrien5555's avatar
adrien5555
Helper 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.

savanahubio's avatar
savanahubio
Frequent Visitor
7 years ago

This is the 3rd time this has randomly happened to me. I have not changed the source data. Does any one have a resolution? 

 

Each time this happens I have to start from scratch and add the source again, add my conditional columns, etc. I basically have to redo my entire report. 

 

So far I have tried deleting all the "Changed Type" tasks from the query editor, re-installing Power BI, clearing my Power Bi cache. And no luck. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Is there any log that will give me even a hint as to which column is throwing the type mismatch (or better yet, the row)? My DAX for this table is over 200 lines long. Last data refresh previews just fine, but is throwing the DISP_E_TYPEMISMATCH error when I go to the report.