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
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!
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