Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Everyone
New Member

Sequentially search each item in a list on a website and return info based on each result

I have a list of companies that I need to seach for individually on a website. Once each company has been found, I need to return certain data items, such as date of registration and director names (all publically available info). How can I automate the input of each company name into the search field on the website and import the data for each company's resulting page?

3 REPLIES 3
Anonymous
Not applicable

Hi @Everyone ,

 

I second @PhilipTreacy  idea.
Other than that this might be helpful.

16 Tools to Extract Data from Website (softr.io)

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

PhilipTreacy
Super User
Super User

Hi @Everyone 

 

You can't do this with PQ - it can't interact with a web page in this way.

 

You could try entering the company name on the web page, clicking the Search/Submit button and see if the URL chnages to show the search parameters.  For example you might search for Microsoft and after clicking the Search button the URL changes to:

 

https://somewebsite.com/?company=Microsoft

 

You can use this URL structure to make multiple calls to the website for the data on each company.  Create a column with the company names, then create a column that calls (for example) Web.Contents for each company.

 

Alternatively you can try Power Automate or a solution using VBA with Selenium, or there are multiple ways to scrape data using JavaScript or Python.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hi, thank you for your reply. That gives me a few things to try!

It looks like each company has a unique URL - they are not predictable but I can hopefully use VBA to find out what each one is.

 

thanks

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors