in EXCEL, "data - from web" retrieve from https://www.espn.com/golf/leaderboard doesnt work, but works in Power BI

Question

Hello, Im trying to retrieve data in EXCEL via "data - from web" option from https://www.espn.com/golf/leaderboard site, but I do get this error:

"Error: The remote server return an HTTP status code '404' when trying to access 'https://www.espn.com/golf/leaderboard"

I do the same operation in PowerBI and I do get several tables that I can import.

**Couple of observations:**1) I already tried in a personal computer in excel, same error. Suggest you also try yourself, have you tried in your excel in your personal computer?
2) The "web" tab displayed during the "site refresh" process in the EXCEL power query shows a message that says: "this browser isn't supported anymore". Does Microsoft need to update something on the Query code of Excel? Because power BI does work and technically "Data - get data from web" is the same functionality in both excel or power BI.
3) This clearly isnt a ESPN website or security issue because:

• It worked in excel before, now it doesn't AND
• As said above, it works in PowerBI, but doesn't in Excel.

Why does it work in PowerBI, but doesn't work in Excel? Did the power Query functionality in EXCEL break?

Thanks a lot!

Answer 1

https://www.espn.com/golf/leaderboard

I put the URL without "/" it seems work. But I don't know if the result is correct.

If I put the URL https://www.espn.com/golf/leaderboard/, then it will get 404 error. Same as PBI desktop.

Answer 2

exactly, but if you try in PowerBI, it works.

Does microsoft need to do some updates/fix to excel power Query?

Answer 3

Here i my test result. Hope it helps.

https://www.espn.com/golf/leaderboard

https://www.espn.com/golf/leaderboard/

Answer 4

Hi Snow

I did a small update on my post and here is the update part which serves also very well as my reply to you:

**Couple of observations:**1) I already tried in a personal computer in excel, same error. Suggest you also try yourself, have you tried in your excel in your personal computer?
2) The "web" tab displayed during the "site refresh" process in the EXCEL power query shows a message that says: "this browser isn't supported anymore". Does Microsoft need to update something on the Query code of Excel? Because power BI does work and technically "Data - get data from web" is the same functionality in both excel or power BI.
3) This clearly isnt a ESPN website or security issue because:

• It worked in excel before, now it doesn't AND
• As said above, it works in PowerBI, but doesn't in Excel.

Answer 5

Hi Elio,

Greetings! Thank you for posting to Microsoft Community.

It could some local security application restrict your request to that website. Try it on another network.

Best Regards,

Snow Lu