Forum Discussion
Post ProdigyOLE 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
Community Championare 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?
Post Prodigy- vanessafvg
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
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
