sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
Depending on when you go to this url (between Sunday and Thursday I guess), the table of football stats at this link will be multiple pages.
However, I can't for the life of me figure out how to query beyond page 1 because the url doesn't change (it doesn't even change from passing yards etc moving from table to table)
On some pages I used to be able to add things like print_row=9999 to the end of the url....doesn't work here. With Google Sheets even page 1 doesn't consistently pull in.
Is this something I can do with power query and I'm just missing how? Haven't used that much.
I'm on 365
However, I can't for the life of me figure out how to query beyond page 1 because the url doesn't change (it doesn't even change from passing yards etc moving from table to table)
On some pages I used to be able to add things like print_row=9999 to the end of the url....doesn't work here. With Google Sheets even page 1 doesn't consistently pull in.
NFL News, Scores, Fantasy Games and Highlights 2020 | Yahoo Sports
Comprehensive National Football League news, scores, standings, fantasy games, rumors, and more
sports.yahoo.com
Is this something I can do with power query and I'm just missing how? Haven't used that much.
I'm on 365