cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
datadad84 Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Nathaniel_C Super Contributor
Super Contributor

Re: How to Properly Import an XML file

Hi @datadad84 ,

 

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

View solution in original post

2 REPLIES 2
Nathaniel_C Super Contributor
Super Contributor

Re: How to Properly Import an XML file

Hi @datadad84 ,

 

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

View solution in original post

datadad84 Regular Visitor
Regular Visitor

Re: How to Properly Import an XML file

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 381 members 3,991 guests
Please welcome our newest community members: