Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@Anonymous , refer
https://www.myonlinetraininghub.com/scrape-data-multiple-web-pages-power-query
https://www.youtube.com/watch?v=n0bSddoCmss
https://www.youtube.com/watch?v=6PZSZ53iSos
https://www.youtube.com/watch?v=s_5Jk8_fHjA
Hi @Anonymous
This blog post should answere your question.
https://www.myonlinetraininghub.com/scrape-data-multiple-web-pages-power-query
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |