Forum Discussion
100+ Web connections
Hi, Akshay123
If the 100 queries have similar query results, an efficient alternative to scrape data is to use a function and custom column. You may need to convert the query you created earlier to pull data from one web page into a function and then invoke the function by passing the input argument.
You can refer to these related tutorials for more information.
How-to-extract-data-from-multiple-webpages/
Scrape Data from Multiple Web Pages with Power Query
script running looping URLs and get data
Best Regards,
Community Support Team _ Eason
Hi, Akshay123
If the 100 queries have similar query results, an efficient alternative to scrape data is to use a function and custom column. You may need to convert the query you created earlier to pull data from one web page into a function and then invoke the function by passing the input argument.
You can refer to these related tutorials for more information.
How-to-extract-data-from-multiple-webpages/
Scrape Data from Multiple Web Pages with Power Query
script running looping URLs and get data
Best Regards,
Community Support Team _ Eason