How to use API using Free access key in power query

[Amar-Agnihotri]

Hello guys, 

I found a code and pbix file here to create Historical currency exchange rates but when i tried to run that file it is showing error for API access key. I have access key but i have never used API in power query before so i am not able to undrstand where and how to put this key . I shall be thankful if anybody can help me regarding that. I am attaching the snapshots and the pbix file here.  A function is created to get historical ratyes using API and a Query has been used to create a table of dates 

Thanks in advance 

[Watsky · Accepted solution]

Hey @Amar-Agnihotri ,

I took a look at the instructions provided by exchangeratesapi as there are many ways an API call could work depending on how it is setup. To write out the key for this API you will need to put the key in right after your date so it will look like this:

http://api.exchangeratesapi.io/v1/2013-03-16?access_key=key goes here&symbols=USD,AUD,CAD,PLN,MXN&format=1

One thing to note is that the free key does not allow for you to set the base so you'll need to remove that from your code if you're using the free version.

Quickstart Guide | exchangeratesapi API

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.