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

Anonymous
2023-02-15T23:41:30+00:00

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!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

11 answers

Sort by: Most helpful
  1. Anonymous
    2023-02-17T16:12:45+00:00

    I haven't this permission. Hope it will be fixed in future.

    Was this answer helpful?

    0 comments No comments