Power Query We couldn't convert to Number

[tiskepio12]

I'm new to Power Query and I'm having issues loading the data. Some of the values contain alphabets and/or characters that are giving me errors and are not being loaded properly. How can I load the entire dataset that includes non-numeric values that is causing the error?

[robindk · Accepted solution]

You need to make sure the coloumns you have defined in your set is aligned with the values that could be present in that coloumn. In this case it seems like you are getting non-numeric values in a coloumn defined as numeric. You can either 1) change the coloumn type to text, or 2) replace errors in the coloumn with null.