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