Forum Discussion
Solved
Bulk import data from >2000 webpages to Excel
Hi there.. I need to import some data from >2000 webpages into excel (or any other database). I have the complete list of webpages. I found a few tutorials where Power Query was used to solve the is...
Yes, that could be. You may delay an execution of each call with Function.InvokeAfter(). More details at Using Function.InvokeAfter() In Power Query and others like Building delays into Power BI API queries — Function.InvokeAfter() and Google Maps API
Thank you for the guidance sir. It worked out pretty well. Turns out, without a premium membership, the website only entertained 10 requests at a time. Thanx again.
Jodhvir , you are welcome