Results 1 to 4 of 4

Thread: Tables not showing up in Query-Editor

  1. #1

    Tables not showing up in Query-Editor



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, I'm currently trying to access tables from the following website:

    http://www.basketball-reference.com/...702030ORL.html

    The problem I am having is with the "Line Score" table and the "Four Factors" table. (line_score - four_factors)

    This used to not be a problem, so I am wondering if the webmasters made it more difficult to access these tables. For some reason those 2 tables are not showing up in the Query-Editor for extraction.

    Please can someone check to see if they have better luck?

    I used to do regular web-query imports, to access the table data, but that stopped working after the webmasters commented the data in the source code. I had to start using Power Query, which did me well for some time, but now that isn't working anymore.

    Any help would be much appreciated.

    Thank you.

  2. #2
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Posts
    164
    Articles
    0
    Excel Version
    2016
    BBMB,

    Tried it with 2016 Excel Get Data and no luck, think the webmasters have played with the puppy, got this https://www.screencast.com/t/ZFtbzQZKjsL2 and none are the tables that you want

    Ed

  3. #3
    Thanks for trying Ed, even though you confirmed my biggest fear.

    I guess Get and Transform has its limits.

    I'm going to try and find another way to scrape.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,401
    Articles
    45
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Yep, looks like they are using javascript, which is a total killer for Power Query.

    That's the big issue with referring to external pages... they're not under your control.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •