+ Reply to Thread
Results 1 to 5 of 5

How to use Power Query to load a subtab in Excel?

  1. #1
    Registered User
    Join Date
    06-17-2019
    Location
    Singapore
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2

    How to use Power Query to load a subtab in Excel?

    Hi,

    Anyone has any idea how to load a subtab from a website using power query?

    For example, in a website it usually loads the hourly tab when i do power query for this page but is it possible to do power query and let it load the daily tab instead?

    Thanks in advance and much appreciated for the help.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How to use Power Query to load a subtab in Excel?

    Probably, but it's really hard to advise without seeing your existing query code, and the website...
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    06-17-2019
    Location
    Singapore
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2

    Re: How to use Power Query to load a subtab in Excel?

    Theres really nothing much to my query code, basically i just use "Get data from Web -> check the box to import entire webpage -> load"

    The webpage is: investing.com/equities/ascott-residence-trust-technical

    Trying to get web query to load the "Daily" tab instead of the "Hourly" tab.

    Thanks.
    Last edited by JSTAN1989; 06-17-2019 at 07:01 AM.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How to use Power Query to load a subtab in Excel?

    Yeah, that's tricky, as the content is javascript rendered...

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: How to use Power Query to load a subtab in Excel?

    This'll get you the HTML result as text, someone may be able to parse it for you if you're only after a specific part:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  2. Power Query and Power Pivot Table !!
    By haitham.shop in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2018, 06:15 AM
  3. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  4. Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  5. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  6. Excel Power Query - Can it do what I need?
    By Spiros in forum Excel General
    Replies: 2
    Last Post: 08-24-2016, 11:23 AM
  7. Power query load to connection
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 08-15-2016, 05:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1