Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.

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


Go to My LinkedIn Page


@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.