Forum Discussion
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 ...
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