import exchange rate from oanda.com

[Jeanxyz]

I need to import into Power BI month-average and month-end exchange rates from oanda.com to Power BI for different currencies and years. I'm wondering if anyone has done this before?

I saw oanda gives API keys, I'm wondering if anyone can show me how to import the rate into PB using API keys. I have tried the web connector, there is only current exchange rate for a few currencies available. 

[v-stephen-msft · Accepted solution]

Hi @Jeanxyz ,

Here's the similar post about using a api as a data source:

Solved: Using a REST API as a data source - Microsoft Power BI Community

And there's a blog you can refer to:

Importing data to Power BI using REST APIs and automatically updating the dashboard

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Jeanxyz , Are you looking for oauth2?

https://blog.crossjoin.co.uk/2021/08/29/connecting-to-rest-apis-with-oauth2-authentication-in-power-...