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
Thanks see screen shot of this...
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
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!