Forum Discussion

efilipe's avatar
efilipe
Helper IV
6 years ago
Solved

Import XML from FetchRSS

Hi guys,

 

I'm trying to make a POC using FetchRSS website.

 

I'm adding pages to read the RSS and, for each, it gives me an URL with a XML file, like:

 

http://fetchrss.com/rss/5df10eed8a93f812478ba93f878438b4567.xml

 

This is to read a profile from Instagram.

 

I want to extract more than one XML (read more profiles) and join all in a big transformation in PowerBI, once.

 

It has has the same structure, but I might add or remove something for time to time.

 

Any ideas?

 

Thanks!

Need Help
Show and Tell
Tips and Tricks
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi efilipe ,

     

    First of all, we need to create a table to store all the URL of xml, we can also get them from SQL or Excel.

     

    Then we can add a custom column to get content from all the URL.

     

    Xml.Document(Web.Contents([XML_URL]))

     

     

    Finally we can expand the content of this new column to get what we want.

     

    Sorry for that we cannot share all the quiers.


    Best regards,

     

2 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi efilipe ,

     

    First of all, we need to create a table to store all the URL of xml, we can also get them from SQL or Excel.

     

    Then we can add a custom column to get content from all the URL.

     

    Xml.Document(Web.Contents([XML_URL]))

     

     

    Finally we can expand the content of this new column to get what we want.

     

    Sorry for that we cannot share all the quiers.


    Best regards,

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi efilipe ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,