Using that approach, you just have one API call per combination of rates from and rates to parameters. Then use the exchange table in merge with other tables. The method that I suggest, and it works for billions of records, is to use dataflows to create an exchange table. If you call this function in a table with 10,000 rows, it means it will be 10,000 API calls, which you need to get a paid version of the API for that.
CURRENCY CONVERTER USD FREE
Why? This is a free API, and has the limitation of 100 calls. You can create the function above in Power Query in Power BI Desktop, and then use it in other tables, However, I strongly recommend to refrain from doing so. Remember that you have to paste your APIKey instead of the paste-your-api-key-here in the script above.
#"Converted to Table" = Record.ToTable(Source), Source = Json.Document(Web.Contents("",)), Source = (#"From Currency" as text,#"To Currency" as text) as number=> The function mainly just expand to the result value. So I ended up using this URL and building a Power Query function that does the conversion using the the API. Then it works with a URL such as below to give you the Exchange rate: You need to get a free API Key first Īfter entering your email address, the API key will be emailed to you. Yes, absolutely free, and the good news is that it works perfectly fine. Currenc圜 is one of the websites that offers you a FREE currency converter API. There are many websites and services for currency exchange rate tables. This post is about a function that gives you the latest currency rate using Power BI and Power Query. You either need to keep an up-to-date table of all new currency rates and use that in your Power BI solution, or use a function that gets the rate from one of the live services. If you ever need to convert amounts from one currency to another, you face the challenge that currency rates are not constant.
0 kommentar(er)
