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
