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:

    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
    Excel Version

    Tried it with 2016 Excel Get Data and no luck, think the webmasters have played with the puppy, got this and none are the tables that you want


  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
    Nanaimo, BC, Canada
    Blog Entries
    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: -||- Blog: -||- 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