Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SebbyP333
Helper I
Helper I

Getting additional table rows from Website

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

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @SebbyP333 

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

vxiaotang_0-1646202383031.png

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
Community Support
Community Support

Hi @SebbyP333 

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

vxiaotang_0-1645077750690.png

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.