Forum Discussion
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
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_CCommunity 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- AnonymousNot applicable
Thank you Nathaniel, that worked! I had to continue clicking on that button to get to the data but it worked! Much thanks.