Getting additional table rows from Website

[SebbyP333]

Hello Community,

I am using the get data from web and there is a table with economic data.  On the website you press the 'Show More' button and the website loads additional rows in the table.  Using the web get data in Power BI i only get the initla table data and not all the rows.  How do i get the additional rows in the table.  

Website is below...

United Kingdom Services Purchasing Managers Index (PMI) (investing.com)

Thanks in advance.

Seb

[v-xiaotang]

Hi @SebbyP333 

I find a related article, you can try the solution below to scrape pages with infinite scroll,

How to scrape pages with infinite scroll: extracting data with Instagram scraper | Diggernaut

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang]

Hi @SebbyP333 

When I connect to the web URL in Desktop, it only has 6 lines of data,

which means that it won't pull more data from its database until you click the show more button. If you want to get all the data, you may need to contact the author of that website to get the correct url.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.