project on web scrapping:

objective: To grab all these data and need to make a report

Take this url and go to the power query editor/PowerBI Desktop to get data web

Interested column URL’s are selected

Power Query editor:

manage parameters:

this text it’s just a value the list of values

Make this url as dynamic:

Populate table from the list:

power query will automatically fetch all the data

To get related searches:

Manage parameters:

Creating a defined function:

Associate this Search Products with this Products table:

Final:

Reference File: