Forum Discussion
Currency code not found from xe.com connection
Hi oanam ๏ผ
If what you need is the Live Currency Rates table, I donโt think you need to update the date. As shown in the figure below, when you refresh the report, it will display the latest data.
If you need Table1, then you can refer to https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters to create dynamic M query parameters.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey oanam ,
for me it looks like the website changed.
I guess you have to add the date:
https://www.xe.com/currencytables/?from=GBP&date=2021-04-12#table-section
But they also offer an API, so you might consider that:
Currency Converter API & Exchange Rate API | XE
Thank you, adding the date works. It used to connect to the source without a date and so whenever I was refreshing the report in PowerBi, the exchange rate on the day would automatically feed in. Is this not the case anymore?
I guess that the APIs mentioned don't come for free, is it?
Hey oanam ,
I don't know the website, so check there.
Otherwise you have to create the date dynamically in M and then use it for the URL.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution โ๏ธ and give it a thumbs up ๐Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic