{"id":3826,"date":"2021-12-11T22:07:58","date_gmt":"2021-12-12T06:07:58","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3826"},"modified":"2021-12-11T22:08:00","modified_gmt":"2021-12-12T06:08:00","slug":"how-to-download-exchange-rates-in-power-bi","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3826","title":{"rendered":"How To Download Exchange Rates In Power BI"},"content":{"rendered":"\n<p>I\u2019m going to show you in this tutorial\u00a0<strong>how you can download exchange rates into your Power BI data model.\u00a0<\/strong>This is perfect if you need 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.\u00a0<strong>You may watch the full video<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How To Download Latest Exchange Rates Into Your Power BI Model\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/9oPFgHvGyKc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>You want to grab the data from a source, in this case, a website and bring it into your model. From its rawest form, you\u2019ll then want to perform some simple transformations and updates until it\u2019s ready to be integrated into the data model. The downloaded exchange rates, in theory, should also automatically update as they\u2019re updated on the website where they come from.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How To Do A Web Query<\/h2>\n\n\n\n<p>The first thing you need to do is query the web that has relatively wide exchange rate data. You go into the\u00a0<strong>Query Editor<\/strong>\u00a0whenever you need to review any data before bringing it into your model.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/1-3.png\" alt=\"\" class=\"wp-image-106360\"\/><\/figure>\n\n\n\n<p>Then, you go to&nbsp;<strong>New Source<\/strong>&nbsp;and click on&nbsp;<strong>Web<\/strong>.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i2.wp.com\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/4-2.png?fit=1024%2C591&amp;ssl=1\" alt=\"download exchange rates\" class=\"wp-image-106364\"\/><figcaption>inside the Query Editor<\/figcaption><\/figure>\n\n\n\n<p>That will bring you to this pop-up box, where you place the web URL.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/5-4.png\" alt=\"\" class=\"wp-image-106367\"\/><\/figure>\n\n\n\n<p>I download&nbsp;<strong>exchange rates from the website,<\/strong>&nbsp;<strong>XE<\/strong>. It\u2019s one of the most well-known online resources for exchange or currency rates. Everything is going to be against the USD, as it should be, because that\u2019s how currency rates are quoted in the market.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i1.wp.com\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/5.1.png?fit=1024%2C576&amp;ssl=1\" alt=\"download exchange rates\" class=\"wp-image-106369\"\/><\/figure>\n\n\n\n<p>Once you click OK, it\u2019s going to query the website and the most recent data (in this case exchange rates) in that website. Then, it\u2019ll give you&nbsp;<strong>a few options when the<\/strong>&nbsp;<strong>Navigator&nbsp;<\/strong>box pops up. It\u2019ll give you Live Currency Rates, but&nbsp;<strong>choose Table 0<\/strong>. You\u2019ll then see the detailed preview, which shows you what you\u2019re going to get.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i1.wp.com\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/6-3.png?fit=1024%2C646&amp;ssl=1\" alt=\"download exchange rates\" class=\"wp-image-106373\"\/><\/figure>\n\n\n\n<p>As you can see, this is very useful wherever you may be in the world because it has every type of currency conversion.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Filtering The Currencies<\/h2>\n\n\n\n<p>Click on&nbsp;<strong>OK&nbsp;<\/strong>to import it into the Query Editor, and then you can change the table name. In this example, I named it&nbsp;<strong>Currency Rates<\/strong>.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i1.wp.com\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/7.1-1.png?fit=1024%2C597&amp;ssl=1\" alt=\"download exchange rates\" class=\"wp-image-106378\"\/><\/figure>\n\n\n\n<p>Then, you\u2019d probably want to filter it by the currencies that you\u2019ll most likely use or that are most relevant to you.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>What\u2019s great about Power BI is that it will remember whatever filters you put in place.<\/p><\/blockquote>\n\n\n\n<p>To do this, click on the drop-down arrow of the Currency Code and click on your chosen currencies. Click OK and it will load up the filters.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i1.wp.com\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/8-2.png?fit=1024%2C595&amp;ssl=1\" alt=\"download exchange rates\" class=\"wp-image-106383\"\/><\/figure>\n\n\n\n<p>This will give you a compact table, showing only the currencies you chose.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i0.wp.com\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/9-1.png?fit=1024%2C300&amp;ssl=1\" alt=\"download exchange rates\" class=\"wp-image-106386\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Making Changes and Updating The Currencies<\/h2>\n\n\n\n<p>Click on Advanced Editor and you\u2019ll see the details. The&nbsp;<strong>Filtered Rows<\/strong>&nbsp;here will always be remembered by Power BI. These are the currencies or filters that you chose.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/10-1.png\" alt=\"download exchange rates\" class=\"wp-image-106388\"\/><\/figure>\n\n\n\n<p>The Filtered Rows are going to hit the original source first, so if you want to modify it, this is where you can make the changes. It\u2019s going to always give you the most recent data. If the rates will be updated on the website where you got them, they\u2019re going to be updated in your model as well when you&nbsp;<strong>Refresh&nbsp;<\/strong>the query.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i1.wp.com\/blog.enterprisedna.co\/wp-content\/uploads\/2020\/05\/11-1.png?fit=1024%2C552&amp;ssl=1\" alt=\"\" class=\"wp-image-106391\"\/><\/figure>\n\n\n\n<p>You can then use this table of currencies in your model.&nbsp;<strong>Remember to build your model correctly with the appropriate relationships.<\/strong>&nbsp;You can make this as a lookup table and connect it to your transaction table that might be in a variety of different currencies, for example. You can also integrate it into your calculations and get the home currency you might want to revalue.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>This is a unique tutorial but one that\u2019s well worth working through if this is the type of work that you do inside Power BI. I walked you through the process on how to download exchange rates from a well-known website. This gives you the ability to do that without any manual intervention.<\/p>\n\n\n\n<p>Ref: https:\/\/blog.enterprisedna.co\/how-to-download-latest-exchange-rates-into-your-power-bi-model\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019m going to show you in this tutorial\u00a0how you can download exchange rates into your Power BI data model.\u00a0This is perfect if you need 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.\u00a0You <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3826\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[980],"class_list":["post-3826","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-download-exchange-rates-in-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3826"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3826\/revisions"}],"predecessor-version":[{"id":3827,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3826\/revisions\/3827"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}