SharePoint List Connection Error Message: "There may be additional results to return"
Published: 24 Jan 2018 Last Modified Date: 04 Nov 2019
Issue
When refreshing a SharePoint List in Tableau Desktop, the following error might appear:
There may be additional results to return that were missed by the query. Specify a higher page size to get all results.
Environment
Tableau Desktop 10.4
SharePoint Lists
Resolution
Use the attached TDC file to increase the number of rows requested.
Cause
By default the SharePoint driver requests the data 1000 rows at a time. This setting is called "Page Size" and is controlled by the driver. A 1000-row page size works just fine with a standard list, where repeated queries are sent for each 1000 rows in the list. However, when the list is an Event List, this error occurs when the list is longer than 1000 rows.
Additional Information
So far this error has only been encountered when connecting to an Event List type of list in SharePoint Lists.