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!
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
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP