Forum Discussion

mmossman's avatar
mmossman
Frequent Visitor
3 years ago
Solved

Converting Value to Number Error

I have a column of serial numbers where the majority of the data is numeric but there are some that are alphanumeric. I have the column formatted to text but I am still getting an "error converting v...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi mmossman 

     

    Usually Power Query will change column data types automatically after you connect to the data source at the first time. Please click the first "Changed Type" step in Applied Steps pane to check whether this step has the same error. If it does have the same error, remove the step. Then modify the serial number column to Text type manually. Change data type of other columns too. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi mmossman 

 

Usually Power Query will change column data types automatically after you connect to the data source at the first time. Please click the first "Changed Type" step in Applied Steps pane to check whether this step has the same error. If it does have the same error, remove the step. Then modify the serial number column to Text type manually. Change data type of other columns too. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • mmossman's avatar
    mmossman
    Frequent Visitor
    3 years ago

    That did it. I also found some additional steps where PowerQuery kept trying to change it back so I fixed those also. No errors on refresh anymore.