TransWikia.com

Is it possible to get all table items from web to excel power query?

Super User Asked by Coding Newbie on December 9, 2020

I need to get table data from a single page site and load them to excel power query so it can be easily refreshed.

The problem is that on site view, the table has a lot of items so it shows only the first 50 items and i need to click next to see the next set of items and so on. When i load the table in excel power query, it only gets the first 50 items. Is it possible for power query to get all items instead of the 50 items?

Any help will be appreciated. Thanks!

One Answer

This is the limitation from the site, you can't solve it in Power Query.

Answered by Máté Juhász on December 9, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP