Is there a way to get the historical exchange rates for the dates I have entered in powerbi, so that when there are new dates entered, the exchange rate is automatically placed for that date?
I need it to be daily. I tried using json, but it only lets me specify the dates manually, and I need this to be dynamic.

If someone could please shed a little bit of light over this problem, I would really appreciate it.
Thanks.