power Query Premierleague.com

[mickyflash]

Hello. I am a football Stats man, and I have been trying to run a PowerQuery using my very limited knowledge with even more limited success!


For example on this page : https://www.premierleague.com/stats/...s/goals?se=210 I am looking for this information here:

It is struggling to find any tables and when it does it will only pull up the 20 rows showing on the page, and I am looking for the information from all the pages using the Next page delimiter OR gives me the top all time scorers rather than this current season.


PremierLeague.com have an array of information available and I would like to gather all of these stats in my spreadsheet so I can analyse performance

I am well out of my depth and this community has been very helpful in the past so I wonder if anyone can help?

 

[mickyflash]

UPDATE:


OK, I can work around recieving the all time data rather than the current season. Ive managed to find tables for all of the stats. My biggest issue is only loading the 20 rows shown on the page rather than the full results.

the next page icon highlighted above does not change the url, is there any way round this? help would be graetly appreciated