Forum Discussion

Ben_Ges's avatar
Ben_Ges
New Member
5 years ago
Solved

XML import only imports first line

Hi,   I am trying to import a .xml into Power Query in Excel. The file has the following structure: <?xml version="1.0" encoding="UTF-8" ?> <?xml-stylesheet type="text/xsl" href="retainvarsexport...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    In your first pic, just click on the word Table in the Body column to drill to your variables.

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

In your first pic, just click on the word Table in the Body column to drill to your variables.

 

Pat

 

  • Ben_Ges's avatar
    Ben_Ges
    New Member
    5 years ago

    mahoneypat, it worked. Thank you. 🙂 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Pat,

     

    I have a similar problem. But I would like to import all tables (not only variables of one column). My xml file is structured hierarchical containing lots of tables. 

     

    Is there a simple way to import all tables?

     

    Best regards, Jacob

    • Posenas's avatar
      Posenas
      New Member
      3 years ago

      Hi, did you solve this? Can you share how?