Convert to Number error

[Anonymous]

Hi, I am trying to upload an excel sheet into PowerBI I am in Power Query Editor, I have converted the column to text & it is still giving me the error "We couldn't convert to number"

any ideas? it is driving me crazy

[v-stephen-msft]

Hi @Anonymous ,

I may have reproduced your problem. This is because your Vendor column contains a value of ‘10357a’, which is not a number.

Please check your Vendor column, you can find the problematic row by filtering as follows.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Stephen, That is why I converted the column to Text, but it is still trying to convert it to a number. I'm not sure what I have done wrong & why it won't accept that 

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

If you don't want to automatically detect the data type, you can turn off the related functions through the following article.

Data types in Power Query | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks, I have done this as it was the easiest way to create the result I want, but not sure why it wouldn't accept my change data type

[selimovd]

Hey @Anonymous ,

I guess that happens in a step before.

Can you show all the steps on the very right side?

There is usually an automatic conversion, make sure this  conversion it not converting the column to a number.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Here is the step, the remove errors steps afterwards are me removing the error lines so I can move on to processing the visuals