Forum Discussion
Data type issue, Alpha numeric column is loaded data type whole number
when you import data Power Query does it's best to set the data types for you. So probably in your case it "Sees" a whole bunch of whole #'s and assumes the whole column is that, and sets the column as such. Which is why your alphanumeric fields are now errors.
Simple fix. After you import you will see a "Changed Type" step in the applied steps. Delete that out, then you can set that column to text. Be sure to set your other data types as well since deleting that step removes the data typing from all the columns.
when you import data Power Query does it's best to set the data types for you. So probably in your case it "Sees" a whole bunch of whole #'s and assumes the whole column is that, and sets the column as such. Which is why your alphanumeric fields are now errors.
Simple fix. After you import you will see a "Changed Type" step in the applied steps. Delete that out, then you can set that column to text. Be sure to set your other data types as well since deleting that step removes the data typing from all the columns.