Search found 4 matches

by mickyflash1982
Sat Dec 22, 2018 10:26 pm
Forum: Power Query
Topic: power Query Premierleague.com
Replies: 5
Views: 902

Re: power Query Premierleague.com

here is the code for the query let Source = Web.Page(Web.Contents("https://www.premierleague.com/stats/top/players/goals")), Data0 = Source{0}[Data], #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Rank", Int64.Type}, {"Player", type text}, {"Club&q...
by mickyflash1982
Sat Dec 22, 2018 1:09 am
Forum: Power Query
Topic: power Query Premierleague.com
Replies: 5
Views: 902

Re: power Query Premierleague.com

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. https://cdn.pbrd.co/images/HSLRcda.png the next page icon highlighte...
by mickyflash1982
Fri Dec 21, 2018 11:25 pm
Forum: Power Query
Topic: power Query Premierleague.com
Replies: 5
Views: 902

power Query Premierleague.com

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: https://cdn.pbrd.co/images/HSLbobF.png...

Go to advanced search

cron