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 for some reason it still shows errors 

When looking at the error in Power Query and selecting one of the Error cells the message at the bottom of the screen reads "DataFormat.Error: We could not convert to Number." 

I dont want to convert to number that is why I formated the column as TEXT????

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

10 Replies

  • 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