SharePoint List Connection Error Message: "There may be additional results to return"
Published: 24 Jan 2018 Last Modified Date: 27 Jan 2018
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.
Tableau Desktop 10.4
Use the attached TDC file to increase the number of rows requested.
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.
So far this error has only been encountered when connecting to an Event List type of list in SharePoint Lists.
Thank you for providing your feedback on the effectiveness of the article.