Live news feed - rss or similar

[seanstead]

Hi,

I need to include a live news feed from an online source (say latest oil industry news) - this could be a simple RSS.

How can I connect and display this in Power BI?

Thanks

[mahoneypat · Accepted solution]

Is this what you mean?  This query connects to an Oil & Gas General Interest feed, using Web.Contents (wrapped in Xml.Tables).

let
Source = Xml.Tables(Web.Contents("https://feeds.feedburner.com/OilGasJournal-GeneralInterest")),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Attribute:version", Int64.Type}}),
#"Expanded channel" = Table.ExpandTableColumn(#"Changed Type", "channel", {"title", "link", "description", "http://www.w3.org/2005/Atom", "http://rssnamespace.org/feedburner/ext/1.0", "item"}, {"title", "link", "description", "http://www.w3.org/2005/Atom", "http://rssnamespace.org/feedburner/ext/1.0", "item"}),
#"Expanded item" = Table.ExpandTableColumn(#"Expanded channel", "item", {"title", "link", "description", "pubDate", "guid"}, {"title.1", "link.1", "description.1", "pubDate", "guid"})
in
#"Expanded item"

If this works for you, please mark this as the solution.  

Regards,

Pat

[dax]

Hi @seanstead , 

I am not clear  about your requirement, did you want to connect to web? If so, you could refer to desktop-connect-to-web  and desktop-connect-to-web-by-example  for details. If not, could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.