Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Properly Import an XML file

I'm trying to get data from an online XML file to my power bi report. I don't seem to be getting much of anything. Here's my Query:

let
    Source = Xml.Tables(Web.Contents("https://sharepoint.com/teams/BP/Agile/Shared%20Documents/Power%20BI%20Data/Zachs%20Uninteresting%20Things/zachs%20feed%20query1.xml")),
    Table1 = Source{1}[Table]
in
    Table1

enter image description here

  • Hi Anonymous ,

     

    So you see those double headed arrows at the top of the columns? If you click on those, they will expand the tables.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion

    Hi Anonymous ,

     

    So you see those double headed arrows at the top of the columns? If you click on those, they will expand the tables.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you Nathaniel, that worked! I had to continue clicking on that button to get to the data but it worked! Much thanks.