100+ Web connections

[Akshay123]

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

[v-easonf-msft · Accepted solution]

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