Hello, I'm very new to Power Query so I'm stumped at the moment but from what I am reading, I'm positive this can be accomplished in Power BI through Power Query.
I would like to monitor the pricing of our products in the marketplace and have successfully created a query to pull the pricing from a search result on Amazon, however I realized that there's an issue when products are "twistered" together. Amazon's search only returns the best-selling product, so any other products do not appear in the results and instead are grouped on the detail page.
You can search for each product's specific detail page by replacing the ASIN in their link https://www.amazon.com/dp/ASIN
This method would actually allow us to scrape better information than what is available from the search view so I'm really interested in creating a query that can replace the ASIN with a list of ASINs that we have stored in Excel. Can someone please point me in the right direction on how to replace the ASIN as a variable in the source link from a list in Excel and gather all the information in a table?
