Import XML from FetchRSS

[efilipe]

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!

[v-lid-msft]

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,

[v-lid-msft · Accepted solution]

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,