Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Greg_Deckler , it works a treat!

     

    Thanks az38 , I had to change it where it was converting it to a number as Greg_Deckler  mentioned.