cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhannaa
Helper IV
Helper IV

Monthly historical currency exchange rates

Hi all,

I need to import monthly historical exchange rates to my report.

I browsed through some APIs for this and it seems they are all a bit on a heavy side for my needs and for a commercial purpose not free. I understand it, but do you happen to know any good source where to get monthly exchange rates? Another possibility is to add a manual currency conversion table but that won't be my first choice here as it needs to be maintained regularly.

 

1 ACCEPTED SOLUTION
mahoneypat
Super User IV
Super User IV

Did you try this REST API?  I didn't, but it looks free and fairly simple to call for specific dates (or get the latest date with you refresh).

Documentation | Exchange Rates API

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

4 REPLIES 4
mahoneypat
Super User IV
Super User IV

Did you try this REST API?  I didn't, but it looks free and fairly simple to call for specific dates (or get the latest date with you refresh).

Documentation | Exchange Rates API

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Thanks @mahoneypat !

We tackled this issue already in a bit different manner than planned but I'll definitely keep this in mind for similar situations.

Jenni

dhannaa
Helper IV
Helper IV

Yes, I understand it's quite a small task to do manually. It's just that I won't be updating the figures, the report and the source data will be fully maintained by the customer. That's why I would love to find an elegant solution. 

lbendlin
Super User III
Super User III

Put it into perspective - you only need to pull a couple hundred rows once a month. That's something you can do manually by looking up from OANDA.com for example.

 

Also be aware that "monthly" means different things to different people, and that the exchange rates depend on if you are buying or selling.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors