Forum Discussion
Getting Data from an Aria Controls Interactive Table on a Website
I am trying to access the table on this website:
http://www.chemistry-compass.eu/a-z-ansicht/
When I use the "Get Data" > Website it recognizes the table but I can't get it to go past the first 10 items. There is no pagination in the URL so I can't seem to adjust it that way. When I inspect the table it shows the aria-controls for expanding the table or moving to the next page.
Can anyone help me to navigate a table like this?
1 Reply
Hi jclark419,
If the table structure is the same across all web pages, you can create a Query Parameter in Power Query to specify which page or range of values to load. For details, please see: Iterating over multiple pages of web data using Power Query
Best regards,
Yuliana Gu
