How To Download Latest Exchange Rates Into Your Power BI Model

No comments

I’m going to show you in this tutorial how you can download exchange rates into your Power BI data model. These, in theory, should also automatically update as they are updated on the website where we are drawing from.

This will be perfect if you have a requirement to bring in the latest exchange rates for some evaluation work or for financial reports where you have to deal with sales from a variety of different regions around the world.

Exchange Rates

We want to be able to grab this data from a source, in this case, a website and bring it into our model. From its rawest form, we’ll then want to perform some simple transformations and updates until it’s ready to be integrated into the data model.

I’ll show you how to do a web query in this case to a particular website that has a relatively wide exchange rate data.

Exchange Rates 1

Then bring that to the query editor, change around a lot of elements of the table and then import that into your data model so you can then model it up and work with it in combination with the rest of your tables in your model.

Exchange Rates 2

Again, this is a relatively quiet unique tutorial but one that’s well worth working through if this is the type of work that you need to do inside of Power BI.

If you want to review some other techniques around managing exchange rates in your reports check out the below links.

Multiple Currency Logic In Power BI – LOOKUPVALUE Example

Update to Multiple Currencies Management in Power BI – Advanced DAX

Enjoy working through this one.

Sam

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online
Enterprise DNA Events

 

 

***Learn more about Enterprise DNA Membership***membership banner 3

 

***** Related Link*****

How To Deal With Products That Have Changing Prices Overtime In Power BI

 

***** Related Course Modules*****

Advanced Analytics

Business Analytics

Unique Analytical Scenarios

 

***** Related Support Forum Posts*****

Calculate currency exchange impact between 2 years

Converting currency

Translating INR amount to USD based on user slicer selection

For more exchange rate queries to review see here…..

 

***Learn To Master Power BI Through Our Many Virtual Training Workshops***Enterprise DNA Events

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.