cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EVEAdmin
Helper V
Helper V

Currency rates from xe.com

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
Snag_a9fe824.png


Can I please ask for help on this issue?
Thank you.

 

Snag_a9adddc.png

 

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@EVEAdmin 


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=""

V-pazhen-msft_1-1618367205708.png

 

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
EVEAdmin
Helper V
Helper V

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.

EVEAdmin
Helper V
Helper V

@V-pazhen-msft thank you again, that was the solution.

I then solved the Service refresh issue with the solution provided here

V-pazhen-msft
Community Support
Community Support

@EVEAdmin 


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=""

V-pazhen-msft_1-1618367205708.png

 

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

@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.

Snag_1f14d74b.png

 

Jihwan_Kim
Super User
Super User

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 accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

@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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.