Forum Discussion
OLE DB or ODBC error DISP_E_TYPEMISMATCH
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.
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'm having similar issue and I've been looking at it for a month now...
May I know how to check/know which step is causing the error?
I went into edit query and are these Error causing the problem? But these are just date modified and date created which I thought should not impact. Btw, my data source is from excel files on sharepoint. All data from 202105 (after april) cannot be refreshed and get loaded on PBI. In other words, take for eg. only HK file here for May is showing "Error" but all other country May files are not refreshed on PBI.
Any help is much appreciated !
I came across this thread when trouble shooting a similar issue. I had a working PBI file based on Excel source files, and inadvertently broke the file while tinkering with some of the data fields. The solution for me was to adjust the Data Type in the Data tab, to align with the new format I had assigned to that field in Power Query. In my case, I had modified a field that was populating as a date, back to text in PQ but upon loading to PBI - it was trying to convert text back to date, which was throwing the error.
