Power query tables not loading

Jroch314

New Member
Joined
Sep 3, 2023
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hello!
I was just introduced to scraping sports data for fantasy purposes. However, I cannot get the tables on this page to load. Power query loads 2 tables, but there are over 10 on the page. I will include the link and screenshots. I've tried digging into the HTML code for the tables but it's a maze in there and hard to navigate.

 

Attachments

  • Screenshot 2023-09-03 014545.png
    Screenshot 2023-09-03 014545.png
    31.1 KB · Views: 28
  • Screenshot 2023-09-03 014809.png
    Screenshot 2023-09-03 014809.png
    94.4 KB · Views: 24
  • Screenshot 2023-09-03 014824.png
    Screenshot 2023-09-03 014824.png
    29.6 KB · Views: 20

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You will need to specify in your URL the specific tables you wish to load. Once they are loaded once, you will only need to click the Refresh All to update them. This is necessary as each table has a different URL address from the main page.
 
Upvote 0
You will need to specify in your URL the specific tables you wish to load. Once they are loaded once, you will only need to click the Refresh All to update them. This is necessary as each table has a different URL address from the main page.
Yes, I thought so also. Each table has a Share & Export option. Under Share & Export there is Get Link to Table. It will give you a specific URL for each table. But when I load them in power query, it still pulls up the full page. Also, if you just go to the URL they provide for each table, it also takes you to the full page. For instance, the Team Stats table has a subdirectory in the URL of "/years/2022/#team_stats." That seems table specific, but it just loads the full page every time.
 
Upvote 0

Forum statistics

Threads
1,223,320
Messages
6,171,434
Members
452,402
Latest member
siduslevis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top