Forum Discussion
Error in column -Power Query
Hi, I have imported some data from excel and I can see that one of the columns appears to have an error. WHen I selected the column it says - we couldnt covert to number. This column has value...
You likely still have the step in there where this got converted to a number. Likely it is the first Changed Type step in your query. You need to change the data type up there. So, click on your step above your first Changed Type step and switch the column to Text. It should ask you to replace the current step. Say yes.
Hi Anonymous
try to set column AS text before the step that automatically set is as number