Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
One of my reports contacts the xe.com site, to grab exchange rates.
As of today, I get the errors below:
- the top section is the error as displayed in Power BI service. It would seem to miss a column.
- the bottom section is the error as displayed in Power BI Desktop.
I am using the standard web source: https://www.xe.com/currencytables/?from=usd
Here the data source settings
Can I please ask for help on this issue?
Thank you.
Solved! Go to Solution.
I was able to get the following with additional date filter in the URL. Seems you must add a string in the date section.
https://www.xe.com/currencytables/?from=USD&date=""
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
UPDATE.
This link https://www.xe.com/currencytables/?from=USD&date="" will now provide only 2 tables:
- the live rates
- the central bank rates
The first table, Table 1, with today's rates is no longer available.
@V-pazhen-msft thank you again, that was the solution.
I then solved the Service refresh issue with the solution provided here
I was able to get the following with additional date filter in the URL. Seems you must add a string in the date section.
https://www.xe.com/currencytables/?from=USD&date=""
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@V-pazhen-msft many thanks.
That works on PBI Desktop but returns an error on the service. I wonder whether it is caused by those quote symbols, as in the screen shot below.
Hi, @EVEAdmin
I think, the link you mentioned above is not directing to the website you wanted.
I think you wanted to connect the webpage that shows the historical currency ratio. But now, I also could not see what I usually saw before.
I think that is the reason why this error happened.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Jihwan_Kim thank you.
The same link worked until yesterday.
So, either there is an issue at xe.com or they changed something and the source is no longer available. Or, it is available at a new URL.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |