Final Friday Fix: October Challenge

Welcome to this month’s Final Friday Fix! This Friday it’s going to involve a lot of Power Query work.

We recently got a question from one of our readers asking why does Power Query only return with the first 50 records from this site: http://www.quanthockey.com/khl/seasons/2017-18-khl-players-stats.html.

In fact, there are 16 more pages of player data to be extracted from this site (and this may increase over time).

So here is the challenge: how do we use Power Query to automatically and dynamically extract all of the data (that’s presently all 17 pages of player statistics) from this site?

Let us know if you’ve got a solution to this, and how you’ve done it. We will share on Monday what we think is the best way of making this work. Have a great weekend and happy querying!