locked
Power Query website with multiple pages RRS feed

  • Question

  • Hi There,

    Is there a way to use Power Query to extract data from a website that has multiple pages when the URL does not seem to have a page number parameter?

    See the bottom table (Past events) in this site:

    http://www.sqlsaturday.com/events.aspx

    There are multiple pages, but the link to each page is just something like: javascript:__doPostBack('ctl00$ContentPlaceHolder1$GridView2','Page$2')

    Thanks in advance for your help


    Help Others! Don't forget to mark your thread as answered

    Rafael Salas - SSIS and more

    Saturday, January 25, 2014 3:19 PM

Answers

All replies

  • One quick solution would be to run N separate queries (figure out the URL syntax for those next pages) and merge the results together.
    Saturday, January 25, 2014 11:50 PM
  • If there's no URL syntax for switching to the other pages then you're unfortunately stuck.

    Saturday, February 1, 2014 12:18 AM
  • I have in the past delved down in to the AJAX URL syntax for refreshes done that way. It is often actually easier to consume such response formats in Power Query.
    Saturday, February 1, 2014 9:05 PM
  • I have encountered the same problem. Have you found an answer?
    Friday, January 2, 2015 11:28 AM