Forum Discussion

KeithRDH's avatar
KeithRDH
New Member
2 years ago
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...
Need Help
  • wstegemann's avatar
    wstegemann
    2 years ago

    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

wstegemann's avatar
wstegemann
Frequent Visitor
2 years ago

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's avatar
KeithRDH
New Member
2 years ago

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!