Forum Discussion
Bulk import data from >2000 webpages to Excel
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
That's too abstract. URL could be correct, but other steps to transform data could be incorrect. Without the sample it's hard to say what could be done.
Thnku for the reply sir.
With errors I meant that only some showed the error, while others were fine (Also, sometimes different row entries show the errors even though they had no error previously and vice versa). So, I presumed that the error can not be with the urls. I also tried to replicate this in Google Sheets via the importhtml formula. If I run the formula in bulk it shows Errors again and if the same formula is used one by one then no error pops up.
Could it be that the website does not entertain so many requests at the same time? If yes, how can we increase the timegap?
If any other method can be used, kindly elaborate that too.
Thank you.
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