Forum Discussion

Resolver II

10 years ago

Solved

Get Data from RSS Feed

Hello All -

Is it possible to connect to an RSS feed? I'd like to make use of the Bank of Canada exchange rates, which are available as a daily feed http://www.bankofcanada.ca/stats/assets/rates_rss/closing/en_all.xml

Thanks very much!

Travis

Greg_Deckler
10 years ago
Look to the right on the columns and click on the two little arrows, then expand. You may have to do this several times to get to the data you want. Your mileage will vary depending on how the web page/feed is formatted.

5 Replies

Replies have been turned off for this discussion

Greg_Deckler
Community Champion
10 years ago
You want to use "From Web" as in this video:

http://blogs.msdn.com/b/ajmee/archive/2013/07/17/power-bi-why-would-you-ever-need-power-query-when-i-already-have-power-pivot.aspx

Your link no longer works BTW, you probably want:
http://www.bankofcanada.ca/stats/assets/rates_rss/closing/en_all.xml
- a68tbird
  Resolver II
  10 years ago
  Thanks very much for this, however I'm guessing that the information on that RSS page is not structured in a way that Power BI can interpret it. I only get an HTML document, with Kind, Element and Text as tables.
  - Greg_Deckler
    Community Champion
    10 years ago
    Look to the right on the columns and click on the two little arrows, then expand. You may have to do this several times to get to the data you want. Your mileage will vary depending on how the web page/feed is formatted.