Data Format incorrect when loading from an excel file

[KeithRDH]

Hi Im getting really frustrate!! I have an excel file which is upoading to PowerBI one column is alphanumeric and is formated in excel as a TEXT and in Power query it is also formatted as TEXT but for some reason it still shows errors 

When looking at the error in Power Query and selecting one of the Error cells the message at the bottom of the screen reads "DataFormat.Error: We could not convert to Number." 

I dont want to convert to number that is why I formated the column as TEXT????

[wstegemann]

Hi @KeithRDH,

Can you post your query from the advanced editor as well as a picture containing one of the error cells?

[KeithRDH]

This is the screen shot of the Power Query with error message at bottom. Sorry not sure what Advance editor is?

[wstegemann]

On the Home tab there should be an option called Advanced Editor under the Query heading. It basically shows all the code for your query without clicking on each step

[KeithRDH]

Thanks see screen shot of this...

[wstegemann]

Can you send the code for your original SalesOrders table? I believe this query is the error report, which you can remove

[KeithRDH]

Hows this?

[wstegemann · Accepted solution]

Try changing the original

{"Product Code", Int64.Type}

to

{"Product Code", type text}

and then hit close and apply. If the query does not error out you can remove the extra change type steps

[KeithRDH]

You Sir, are a genius. That worked perfectly. I've lost 3 hours of my life but at least I gained faith in humanity. Thank you so much!

[wstegemann]

No problem, you can also have Power BI apply this fix for you automatically in the future by having the original Changed Type step selected while changing your columns and selecting Replace Current when you are prompted

[KeithRDH]

Sorry, now showing all text.