Forum Discussion
Helper I100+ Web connections
Hello Experts
I have a monitoring tool where I have to pass server name into url and fetch the information regarding that server.
I have 100+ list of server names usign that have to establish a connection in Power BI
Making 100+ web connectors is not getting possible in Power BI,
After connecting to 10+ web connections then later started getting failed for new connections because the error says blocking other queries.
Any suggestions that how can I establish a connection
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
1 Reply
- v-easonf-msft
Community Support
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