Forum Discussion

aAmirkHan's avatar
aAmirkHan
Helper III
3 years ago

Data Format Error in Power Query (We could not convert to number. Details: Solarwind.Application)

Hi,

 

I am experience challenge while converting data type of column OHR ID into number where it is showing error like "We could not covert to number - Details : Solarwind.Application.

 

Can you please help me on this error? how can it be fixed?

 

 

 

Thank you 

Kind Regards,

Aamir

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    3 years ago

    Hi aAmirkHan 

     

    Please supply your file or some sample data.  I can't tell from your image what it is that you are trying to convert.

     

    Regards

     

    Phil

    • aAmirkHan's avatar
      aAmirkHan
      Helper III
      3 years ago

      Hi Philip, 

      Thank you for your response, however I can't share you file due to confidentiality in data.

      However, I can give you an example in my column of OHR ID it has consist numeric value 12345678.

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    3 years ago

    Hi aAmirkHan 

     

    If the column only consists of text in the form 12345678 then there would be no errors converting that to a number.

     

    Check the ID column for values that are not numeric in form.

     

    regards

     

    Phil

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I bet you are splitting the data in the column to the left of OHR ID, and your delimiter is returning the text "Solarwinds.Application", where you want it to return just a string of numbers. You may want to handle that by using an each if Text.Contains([Column, "Solarwinds.Application" then (split by delimiter and use "Solarwinds.Application" as the delimiter to get whatever text is after that--know what I mean?

     

    --Nate