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.
Unfortunatly I am now getting this error on a dataset that had been working fine for months. I dont even have any change type commands in my query. The only reason I knew there was an error is because my on premises gateway data suddenly stopped refreshing today and no ones dashboards worked.
Any other ideas on how to troubleshoot?
Thnk you,
Jesse
Never mind! One of our sales reps accidentally typed "Trina" into the sales order number field and hit "save"... sigh. All good now.