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.
I also got this error because my Power BI file and my Windows version had different formats. Commas and points were other way round because of the difference between American and Eurpean formats.
I could fix it by going to Control Panel > Region > Formats > English (United States)
This worked for me too, thanks!