How to Properly Import an XML file

[Anonymous]

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

[Nathaniel_C · Accepted solution]

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]

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