Forum Discussion
When I connect to an XML URL, Power BI only returns document settings
Hi,
I am working with ProjectorPSA data. I ran a report, and they provide a means of connecting to the results of that report via a URL. e.g. website.com/xmlconnectiondetails.xml. When I navigate there in a browser, my data looks correct. However, when I try and put this url into Power BI, the editor returns a single record with the following data:
Kind Name Children Text
Element HTML Table null
So rather than bringing in the data on the page, it looks to me like it is bringing in the data describing the page. Hopefully that makes sense.
Any thoughts on how to fix this?
Thanks,
Scott
12 Replies
- Greg_Deckler
Community Champion
You should have some little arrows in the column heading for Children that allow you to expand the table.
I can keep drilling into the table details, but it never gets to the xml for the data itself. here is a sample of what it drills down to:
Kind
Name
Children.Kind
Children.Name
Children.Children.Kind
Children.Children.Name
Children.Children.Children.Kind
Children.Children.Children.Name
Children.Children.Children.Children
Children.Children.Children.Text
Children.Children.Text
Children.Text
Text
Element
HTML
Element
HEAD
Text
null
null
null
null
null
null
null
Element
HTML
Element
HEAD
Element
TITLE
Text
null
null
Projector | Log In
null
null
null
Element
HTML
Element
HEAD
Text
null
null
null
null
null
null
null
Thanks, though.
Scott
- Greg_Deckler
Yeah, when I told you that Anonymous, I was thinking "well, I probably should have told him that he probably wasn't going to have much luck".
I have yet to really have very good success ingesting XML into Power BI in general. The way XML is structured is so hierarchical that it really doesn't translate to tables very well and you end up drilling down endlessly it seems like. It is almost like you would need to point to an XSL to translate the structure to something useable but since each XML is different...
If anyone has had great success, or even marginal success, with ingesting XML I'd love to know some tricks to making it work.
Something that helped me was changing "HTTP:/" to "HTTPS:/" in the URL, which prompts for credentials and therefore returns tables with data
Thanks to Angry Analytics for the help!
