Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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,
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,
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,
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |