OLE DB or ODBC error Type mismatch

Hi Calumc12 ,

It may be an issue with the type conversion of Column, please refer the following posts, hope them will be helpful.

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-Type-mismatch-Exception-from-HRESULT/m-p/648728

https://community.powerbi.com/t5/Desktop/Error-OLE-DB-or-ODBC-error-Expression-Error-We-cannot-convert/m-p/1195779

https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC-error-Type-mismatch-error-on/m-p/296940#M131019

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-Expression-error/m-p/441189

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.