What this error meaning? Urgent

[Anonymous]

Hello Expert,
How I can deal with this error? what is the meaning? 
be noted that my data was connteced to SQL Server database

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

According to the error message, it seems the value of some field(s) mismatch the current data type. Please review the data and the data type settting of every field for the query Commercial_Import and check if there is any mismatch...

OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))

then you must first  find  them and convert them to ablank or null before you can change it to a whole number?  Or you can just create a a new column that checks if its a number and then puts the number in the new  custom colume ie

if Value.Is(Value.FromText([COLUMN]), type number) then COLUMN else null

---

And you can provide the screenshot of the query Commercial_Import (exclude sensitive data), later we can make troubleshooting and give you a suitable solution. Thank you.

Best Regards

[MahyarTF]

Hi

Please have a look at the following post. it is the same issue with the solution :

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DISP-E-TYPEMISMATCH/m-p/34076#M12207

Appreciate the Kudos