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

Question

Hi,&nbsp;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.&nbsp;Can you please help me on this error? how can it be fixed?&nbsp;&nbsp;&nbsp;Thank you&nbsp;Kind Regards,Aamir&nbsp;

philiptreacy · Answer

Hi&nbsp;aAmirkHan&nbsp;
&nbsp;
Please supply your file or some sample data.&nbsp; I can't tell from your image what it is that you are trying to convert.
&nbsp;
Regards
&nbsp;
Phil

aamirkhan · Answer

Hi Philip,&nbsp;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 · Answer

Hi&nbsp;aAmirkHan&nbsp;
&nbsp;
If the column only consists of text in the form 12345678 then there would be no errors converting that to a number.
&nbsp;
Check the ID column for values that are not numeric in form.
&nbsp;
regards
&nbsp;
Phil
&nbsp;

anonymous · Answer

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?
&nbsp;
--Nate

Forum Discussion

Related content

Error - DataFormat.Error: We couldn't convert to Number. Details J7510

Missing Connection Details

Pricing in details

Fabric capacity metrics - Timepoint Detail

Converting to Percentage