Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
5 years ago

We cannot convert the value 0 to type text

Im getting below error message.  How do I know into which column this is? This is happening after the group rows step.  I am adding pic below...

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    jcastr02 can you click on each step and see on which step you get this error? and we can debug it from there.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    jcastr02 , That seems a bit strange.  Can you check the data type of HC count - It should be the number. If not change it.

    Also, try changing data type or location to Text and check again does it work 

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi jcastr02 ,

     

    You can try to click each step to see which step is wrong, and then open the Advanced Editor in Power Query to see the specific code. There is a blog here, which mentions a similar problem with you and has been solved. You can read it first. If it is still not solved, please provide complete code and data, so that I can help you to do further testing.

     

    Here is the related link.

     

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.