Power query tables not loading

[Jroch314]

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.

2022 NFL Standings & Team Stats | Pro-Football-Reference.com

Check out the 2022 NFL Standings & Team Stats including AFC and NFC results and standings on Pro-football-reference.com

www.pro-football-reference.com

 

[alansidman]

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.

 

[Jroch314]

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.

 

[alansidman]

Seems it is how the web developer set up the pages