Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Convert to Number error

Hi, I am trying to upload an excel sheet into PowerBI I am in Power Query Editor, I have converted the column to text & it is still giving me the error "We couldn't convert to number"

any ideas? it is driving me crazy

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    If you don't want to automatically detect the data type, you can turn off the related functions through the following article.

    Data types in Power Query | Microsoft Docs

     

    Best Regards,

    Stephen Tao

     

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

6 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    Hey Anonymous ,

     

    I guess that happens in a step before.

    Can you show all the steps on the very right side?

     

    There is usually an automatic conversion, make sure this  conversion it not converting the column to a number.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Here is the step, the remove errors steps afterwards are me removing the error lines so I can move on to processing the visuals

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I may have reproduced your problem. This is because your Vendor column contains a value of ‘10357a’, which is not a number.

    Please check your Vendor column, you can find the problematic row by filtering as follows.

     

     

    Best Regards,

    Stephen Tao

     

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Stephen, That is why I converted the column to Text, but it is still trying to convert it to a number. I'm not sure what I have done wrong & why it won't accept that 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        If you don't want to automatically detect the data type, you can turn off the related functions through the following article.

        Data types in Power Query | Microsoft Docs

         

        Best Regards,

        Stephen Tao

         

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