Forum Discussion
Power Participantimport exchange rate from oanda.com
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.
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.
2 Replies
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
Super User
Jeanxyz , Are you looking for oauth2?
