Power Query from Web - what RL to use?

[Back2Basics]

Hi

I am new to Power Query/Power BI, very new. I'm trying to get data from a website, but every time I put the URL in I don't get any tables to select, even though I know the website has loads of data. Do I need to be putting in a more specific address? if so how do I go about finding what URL I should be using so that I get some useful table?

for instance, I was trying to link to http://allthingsfpl.com/fantasy-football/opta-player-zones
the tables available are very limited, despite knowing that there is a lot more available. some of the data is over several 'pages' is there a way to bring up everything over all of the pages using Power Query?

Any help with knowing what URL to use in these instances would be greatly appreciated.

 

[Matt Allington]

it could be that your data is in a java script wrapper or something else that is preventing PQ from seeing it

 

[olivierhbh]

Or maybe your file is not authorized on the website, as the link you provided is for members only.