Connecting to website with load button

[jaryszek]

Hello Guys,

I am trying to write power query connector in Excel to get all data on this page (from Table0 accordingly to power query) : https://waszaedukacja.pl/ranking/polska/szkoly-podstawowe

There is a button with id="caly_ranking" and i have to clik on this to load whole data. 
When i am going to power query, clicking from web, pasting url it is getting me this table but only with 1000 rows. 

How to load data using button in power query? It is possible? 

Best wishes,
Jacek

[rubayatyasmin]

@jaryszek 

It's because data in the page is loaded till1000. See this in PQ.