Forum Discussion

DennisSchlein's avatar
DennisSchlein
Helper III
5 years ago
Solved

Beginner - exchange rate API

Hi  I'm brand new to PBI, and i'm trying to find a solution to making a exchange rate table. I found a model in here where the API endpoint has been updated. Im trying to reach this endpoint...
Need Help
  • NickA01's avatar
    NickA01
    5 years ago

    DennisSchlein 
    We are all always learning;  
    if you just open Advanced editor  then you can replace your code with mine - remember to add in the key. 
    Get Data --> From Web -- Click on Advanced

    Another option to get data for multiple dates would be to use the timeseries mentioned in the documentation but this looks like it is dependent on the subscription you have. 

     

     

    Regarding getting data for different dates, as mentioned by amitchandak  Chris Webbs cross join blog will help. 

NickA01's avatar
NickA01
Resolver III
5 years ago

Just had a look at their site and under FAQ, it states 

If you have a key, you should try the Web API auth

This worked fine in my test; 

 

Here's the query 
let
Source = Json.Document(Web.Contents("http://api.exchangeratesapi.io/v1/" & "2021-07-19?" & "access_key=<ENTER KEY HERE>" & "&symbols=USD,AUD,CAD,PLN,MXN&format=1")),
#"Converted to Table" = Table.FromRecords({Source}),
#"Expanded rates" = Table.ExpandRecordColumn(#"Converted to Table", "rates", {"USD", "AUD", "CAD", "PLN", "MXN"}, {"rates.USD", "rates.AUD", "rates.CAD", "rates.PLN", "rates.MXN"})
in
#"Expanded rates"


By the way-  Not a good idea to share the API key- 

DennisSchlein's avatar
DennisSchlein
Helper III
5 years ago

Hi NickA01 , 

I'm sorry, I must be the worst BI worker in the world.

I cant even get to add json as data source: when trying to link to a URL i get some chrome error 😕

 

would you mind sharing your model?