Forum Discussion

jaryszek's avatar
jaryszek
Super User
3 years ago

Connecting to website with load button

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

1 Reply