Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Proud to be a Super User!
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!
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?
Proud to be a Super User!
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |