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.
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.
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.
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.
Enjoy working through this one.
***** 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
***** Related Link*****
How To Deal With Products That Have Changing Prices Overtime In Power BI
***** Related Support Forum Posts*****
Calculate currency exchange impact between 2 years
Translating INR amount to USD based on user slicer selection
For more exchange rate queries to review see here…..