cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gauravnarchal
Post Partisan
Post Partisan

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

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?

 

gauravnarchal_0-1623857689272.png

 

 

 

1 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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
alekhved
Resolver I
Resolver I

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.

alekhved_1-1623859944739.png

Convert Datatype to Whole Number

 

alekhved_2-1623860027867.png

After conversion remove errors. (right click on Column1)

alekhved_3-1623860067896.png

 

 

2. Select the row Data type as "Text"

 

alekhved_0-1623859689048.png

 

Thanks!

vanessafvg
Super User I
Super User I

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

 

Thank You.

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors