Solved: Re: Historical Currency Exchange rate table in pow...

Amar-Agnihotri · ‎09-17-2021

Hello guys,

I have created a currency exchange rates conversion table in power query. I am getting exchange rates through web link. Since these exchange rates are live exchange rates so I am not able to do historical analysis for the past 2 years of data. Can anyone suggest a link from where I could get currency exchange rates for the last 2 years date wise.

Thanks

jennratten · ‎09-18-2021

This site has historicals available as a downloadable file or an API.

https://fiscaldata.treasury.gov/datasets/treasury-reporting-rates-exchange/treasury-reporting-rates-...

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

View solution in original post

Amar-Agnihotri · ‎09-18-2021

Thanks a lot

jennratten · ‎09-18-2021

You're welcome!

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

jennratten · ‎09-18-2021

This site has historicals available as a downloadable file or an API.

https://fiscaldata.treasury.gov/datasets/treasury-reporting-rates-exchange/treasury-reporting-rates-...

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User