Forum Discussion

hokiefan1113's avatar
hokiefan1113
Advocate I
8 years ago

Using XML API as data source

I'm trying to pass an XML API as a datasource on Power BI, but I'm having a lot of trouble/have no idea how (I've tried multiple ways) as a data source to PBI desktop. Any suggestions or experience w...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Juse use the Web connector:

 

let
    Source = Xml.Tables(Web.Contents("https://www.ncaa.com/news/football/fbs/rss.xml")),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Attribute:version", type number}}),
    #"Expanded channel" = Table.ExpandTableColumn(#"Changed Type", "channel", {"title", "link", "description", "language", "item"}, {"channel.title", "channel.link", "channel.description", "channel.language", "channel.item"}),
    #"Expanded http://www.w3.org/XML/1998/namespace" = Table.ExpandTableColumn(#"Expanded channel", "http://www.w3.org/XML/1998/namespace", {"Attribute:base"}, {"http://www.w3.org/XML/1998/namespace.Attribute:base"}),
    #"Expanded channel.item" = Table.ExpandTableColumn(#"Expanded http://www.w3.org/XML/1998/namespace", "channel.item", {"title", "link", "description"}, {"channel.item.title", "channel.item.link", "channel.item.description"})
in
    #"Expanded channel.item"
hokiefan1113's avatar
hokiefan1113
Advocate I
8 years ago

Hi Greg_Deckler, 

 

Thanks for your response. I've used web connector before, and it's worked for what I was doing (like in your example). But in this case it hasn't. I'm trying to post the XML request (in the first XML body) to the link in the screen shot. The bottom XML body is what I should be getting back. Is it even possible to post a local XML request on PBI? 

 

 

When I use the web connector and put the URL in, this is what happens. 

 

 

I then added ".xml" to the end of the URL, since the Attribute:Message column says "Valid types: text/xml, application/xml" and this happens: 

 

I may be missing something obvious, but I'm rather new working with APIs as well as PBI, so I appreciate any help!

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi hokiefan1113,

     

    I am trying to do exactly what you were trying to do back in June 2018.  Were you able to make it work?  I am lost as to where to enter the XML code that get posted to the URL.

     

     

    Best regards,

     

    Ferdinand