You can then use this table of currencies in your model. If the rates will be updated on the website where you got them, they’re going to be updated in your model as well when you Refresh the query. It’s going to always give you the most recent data.

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. These are the currencies or filters that you chose. The Filtered Rows here will always be remembered by Power BI. Making Changes and Updating The CurrenciesĬlick on Advanced Editor and you’ll see the details. This will give you a compact table, showing only the currencies you chose. Click OK and it will load up the filters. To do this, click on the drop-down arrow of the Currency Code and click on your chosen currencies. What’s great about Power BI is that it will remember whatever filters you put in place. Then, you’d probably want to filter it by the currencies that you’ll most likely use or that are most relevant to you. In this example, I named it Currency Rates. Filtering The CurrenciesĬlick on OK to import it into the Query Editor, and then you can change the table name. You’ll then see the detailed preview, which shows you what you’re going to get.Īs you can see, this is very useful wherever you may be in the world because it has every type of currency conversion. It’ll give you Live Currency Rates, but choose Table 0. Then, it’ll give you a few options when the Navigator box pops up. Once you click OK, it’s going to query the website and the most recent data (in this case exchange rates) in that website. Everything is going to be against the USD, as it should be, because that’s how currency rates are quoted in the market. It’s one of the most well-known online resources for exchange or currency rates. I download exchange rates from the website, XE. That will bring you to this pop-up box, where you place the web URL. Then, you go to New Source and click on Web. You go into the Query Editor whenever you need to review any data before bringing it into your model. Making Changes and Updating The Currenciesįirst thing you need to do is query the web that has a relatively wide exchange rate data.

Download exchange rate s