cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver II
Resolver II

Scrap Multiple Pages

Hello,

 

I have a data coming in from https://clinicaltrials.gov/ct2/results?term=BCG&cond=Covid19&Search=Apply&recrs=b&recrs=a&recrs=f&re...

 

However, when I bring it inside BI, it only shows the first 10 records.

 

Can someone please help me in scraping no matter how many pages are there, without me manually copying pasting stuff in excel.

 

Please help.

2 REPLIES 2
Super User III
Super User III

Hi @nishantchawla 

 

This blog post should answere your question.

https://www.myonlinetraininghub.com/scrape-data-multiple-web-pages-power-query

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Super User IV
Super User IV

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors