Power Query Web Query not returning full record set

RagnarokX66

New Member
Joined
Sep 11, 2011
Messages
36
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/calendars/historical-catalyst-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
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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)
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top