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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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,939
Messages
6,175,533
Members
452,652
Latest member
eduedu

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