Exchange rates in power query

[NoorAlfar]

Hello,

I have a power query to get the exchange rate for multiple currencies on a daily basis from the beginning of this year, I was using this:

https://api.exchangerate.host/timeseries?start_date=2023-01-01&end_date=2023-12-31&base=GBP
but for some reason, the service is not free anymore.

Is there another site that provides a similar service for free 😞

[v-cgao-msft]

Hi @NoorAlfar ,

1. freecurrencyapi.com
2. fixer.io

Please note that while these services offer free plans, they may have limitations on the number of requests per month or the number of supported currencies. Always check their documentation for details. Hope they help.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[NoorAlfar]

Thank you @v-cgao-msft. The first option do not have all the currencies I need, the second one the historical option is not available for the free plan

[mlsx4]

Hi @NoorAlfar 

I use XE (https://www.xe.com/es/currencytables/?from=USD).

You can see how to link it here: https://blog.enterprisedna.co/how-to-download-latest-exchange-rates-into-your-power-bi-model/

[NoorAlfar]

Thank you, what I'm looking for is table of rates on a daily basis:

[mlsx4]

Hi @NoorAlfar 

I also know this one, but I don't know if it has what you need: https://www.x-rates.com/