Forum Discussion
Solved
Data Format incorrect when loading from an excel file
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 fo...
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
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
Thanks see screen shot of this...
Sorry, now showing all text.
Can you send the code for your original SalesOrders table? I believe this query is the error report, which you can remove
Hows this?
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