How to pull exchange rates from a web page into Excel or Power BI

/, Power BI, Power Query/How to pull exchange rates from a web page into Excel or Power BI

This 3 minute video shows how easy it is to link to web page data with Excel.

In this scenario it’s connecting to the Reserve Bank of Australia exchange rates web page.

Get & Transform is built into Excel 2016.

It was previously known as Power Query and is still a free download for Excel 2013 / 2010.

This identical functionality is available in PowerBI Desktop.

The URL if you want to give it a go yourself… or BridgePayday

http://www.rba.gov.au/statistics/frequency/exchange-rates.html

Find out more

Power BI is free to a large extent, and you can do a huge amount without any cost.

Download Power BI Desktop here