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 Championthen 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