Forum Discussion
DataFormat.Error: We couldn't convert to Number - for columns with text and numerical values
Hi mrreisinger ,
I create a sample to reproduce your problem, here's a sample.
After load the table, the Power Query automatically recognizes that the data type of the column is text.
After I change the data type to number, it cause errors. This is easy to understand, because A1, A2 cannot be converted to numeric type.
But now I convert it to text type again, it is still error!
You should delete the error steps in APPLIED STEPS, and then do other operations. Here's a similar thread for your reference.
Additionally, you can catch an error with try and otherwise expression, refer to this document:
Error handling for Power Query connectors - Power Query | Microsoft Docs
iferror-in-power-query-using-try-otherwise
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mrreisinger ,
I create a sample to reproduce your problem, here's a sample.
After load the table, the Power Query automatically recognizes that the data type of the column is text.
After I change the data type to number, it cause errors. This is easy to understand, because A1, A2 cannot be converted to numeric type.
But now I convert it to text type again, it is still error!
You should delete the error steps in APPLIED STEPS, and then do other operations. Here's a similar thread for your reference.
Additionally, you can catch an error with try and otherwise expression, refer to this document:
Error handling for Power Query connectors - Power Query | Microsoft Docs
iferror-in-power-query-using-try-otherwise
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.