Power Query -Web Multiple pages

Thought that I will be able to get help from Excel Guru.Thanks
 
Hey,

What Power Query does is that it finds the html table tags within those web pages (html) and exposes them inside of Power Query. If your page is using something different, like javascript, then Power Query won't be able to easily display the content that you have inside that webpage, thus requiring other methods to find out how your webpage works and how it displays the data that you need. Is not something simple and it often requires knowledge of not only Power Query, but also HTML, CSS, Javascript and other languages, so I can understand why nobody has replied to this thread yet.

I used Fiddler (a 3rd party tool) to find out where the data that you wanted came from. Grabbed the correct url and passed it to Power Query.

The 2nd webpage (bseindia) does have the data inside of table tags so you can just grab the url of that webpage, pass it to Power Query and you should have a better experience than with the first url. The problem with this one is that when you click on the 2nd page it doesn't change the url, so you'd also need to use a 3rd party tool to find out what the url should look like and if it has a "page" parameters so you can apply the same method that I showcase here.
View attachment BSE NSE India.xlsx
 
Thanks a lot for your help.I also noticed that if you click next page,url did not change! Trued changing expandable = _ ,thinking that it will help!! Thank you once again for tracing the url for me.Will open the attachment in laptop and see.
 
Tried.Getting error(BSE)PQE.PNG -Query Not Compatible.I am running MS office Prof Plus 2016
 
You must log in or register to reply here.
Back
Top