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

[gauravnarchal]

Hello

I am getting the error "OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))." when trying to refresh my data.

I have duplicated one column and converted it to the whole number. But in some rows, their alphanumeric character which I think is giving an error. Can you pls help me with how I can resolve this?

[Anonymous]

hi @gauravnarchal ,

If the Column contains both Alpha-numeric, Numeric, Text values, you will not be able to assign the data type = whole number for that column. Here are two steps that you might wanna take now

1. Either filter all the Alpha Numeric values from the column.

Convert Datatype to Whole Number

After conversion remove errors. (right click on Column1)

2. Select the row Data type as "Text"

Thanks!

[vanessafvg]

are you saying you have changed the field to a whole number but there are still some alphanumeric characters in it?  if so that would explain it.   You could remove the error rows.  But what is the rule you need to apply here?  What happens to those values if you only looking for whole numbers?

[gauravnarchal]

@vanessafvg  - I want these errors to be ignored.  Either blank or null

Thank You.

[vanessafvg · Accepted solution]

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

[Ekbal_CPP]

In PowerBi using OLE DB i have imported table so I have table and its has some empty value of some column and while click on load 

it gives error . I have cheked data type in my original DB and powerbi column data type both are same still I get subject line error