Getting Data from an Aria Controls Interactive Table on a Website

[jclark419]

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?

[v-yulgu-msft]

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