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.
Community ChampionReading the post reminds me of a recent one where someone was trying to fix an error by changing the data type 'after' the error has occurred. It can't be done.
If this is the situation, find the step which converts the data to number and delete it (or edit it if you have the skill) and replace it with the change to text type.