Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Power Query Web Query not returning full record set

  1. #1
    New Member
    Join Date
    Sep 2011
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query Web Query not returning full record set


    Power Query Web Query not returning full record set
    I'm doing a web query through "Get and Transform" in Excel 2016

    The following site has one large table on a single page:
    https://www.biopharmcatalyst.com/cal...alyst-calendar

    Excel detects the table but only returns 50 records of the 500+ records I need.

    I thought maybe there was a maximum record setting somewhere but I did not see this anywhere.

    The web scrape returns full results when using the "Get External Data" connection however only returns partial results when going through "Get and Transform." I'd really like to run this through Power Query though.

    Is anyone familiar with this issue? A quick web search did not yield anything helpful.

    Thanks

  2. #2
    New Member
    Join Date
    Nov 2017
    Location
    Hamburg, DE
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Web Query not returning full record set

    Hello,
    I can understand the problem. The error is imho not in the Power Query/Get and Transform but in the programming of the website. I looked at the HTML-source code and realized that a new table definition was created in the last imported line. This is obviously a signal for the import that the (previous) table is over.


    Unfortunately I can not answer, why no other table is offered for selection.

    (Translated from German to English with Google) with Google)

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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