Unable to grab table using GetData>FromWeb; can see in web view only

[doogis2003]

Hello,

I tried using the Get Data > From Web feature to grab an exchange rate table from the following site: Rates Page

There isn't any table data in Table View but I can see it in Web View with the message "Table highlighting is disabled because the page uses Internet Explorer's Compatibility Mode. I'm realizing that the way the website generates this table means I can't use the Get Data > From Web method.

Is there a workaround to copy this table data using VBA or another method?

Thank you,

AC

 

[sandy666]

hm, try to update your office
or try this link as test: https://en.wikipedia.org/wiki/List_of_circulating_currencies

did you try to refresh previous link?

on the end try to select this and if it is works - Edit

 

[doogis2003]

The test on the wikipedia link is successful which matches my previous success with another currency exchange site. There's something about the currencywholesale one that behaves differently...

Tried refreshing previous link multiple times, no luck.

Office is up to date (Microsoft 365 subscription w/ auto-update)

 

[sandy666]

did you try last option from my previous post?

 

[doogis2003]

The last option picture below. I don't have an 'edit' option though but have shown what I do have:

Using the highlighted above, 'Transform Data' results in this:

 

[sandy666]

to eliminate problem with your Excel OR with the link you can try Power BI Desktop
to me this link works, another links too

also you can try advanced option but no big hope

 

[doogis2003]

Odd... this is what I get with (fresh install of) Power BI:

Trying 'Add table using examples' doesn't seem to work either - can see the table but can't select it.

 

[sandy666]

PowerBI with Get Data - from Web

then

 

[doogis2003]

Interesting...other than software version, what else could cause such a difference in what we each see given the exact same URL? I'm thinking a setting somewhere but no idea what. Both of my programs don't seem to identify the table the same way yours do.

 

[sandy666]

maybe rates.currencywholesale.com doesn't like your domain, who knows?

have you tried another table from rates.currencywholesale.com ?

how about example excel file I posted, it works or not? (post#6)

 

[doogis2003]

The example excel file ends up the same. Can see the connection you made but when I open it there's no data there. Looks same as if I try to generate it from scratch.

You might be onto something with the domain. Is that actually possible?

May be coincidence but it's the only condition that was changed - turned on VPN and went back to Power BI and was able to get to this point using exact same steps as before (Get Data > from Web > same URL):

Everything looks fine BUT.... on a refresh, reverts back to

Also, no change in Excel. I still can't get it to show me the table I need "Rates updated...." Can a website be blocking me from seeing the data?

Not seeing another table to use as an example on the currencywholesale site.