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

Hi KeithRDH,

 

Can you post your query from the advanced editor as well as a picture containing one of the error cells?

  • KeithRDH's avatar
    KeithRDH
    New Member
    2 years ago

    This is the screen shot of the Power Query with error message at bottom. Sorry not sure what Advance editor is?

    • wstegemann's avatar
      wstegemann
      Frequent Visitor
      2 years ago

      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

      • KeithRDH's avatar
        KeithRDH
        New Member
        2 years ago

        Thanks see screen shot of this...