Forum Discussion
Dredded DISP_E_TYPEMISMATCH Error
Have a pretty simple Excel file as the data souce. All of a sudden upon performing a refresh I encounter: Ensured there are no errros in Power Query. Went back to the Excel and made sure all...
I went ahead and deleted most of the Applied Steps:
Source - Didn't delete
Navigation - Didn't delete
Promoted Headers - Deleted
Changed Type - Deleted
Removed Bottom Rows - Deleted
Once I deleted Promoted Headers the refresh went though without any error. Although now all my visiuals had errors. I then went back in to Transform Data and selected "Use first row as headers", and everything came back. I have the original data in teh soriuce file so no clue what caused all of this...??
Hi Anonymous ,
The type mismatch error is probably happening while you're doing some conversion for the data in tables.
Looks like this column does not meet the conditions of the conversion type.
Best Regards,
Jay