KNOWLEDGE BASE

SharePoint List Connection Error Message: "There may be additional results to return"


Published: 24 Jan 2018
Last Modified Date: 27 Jan 2018

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.
Did this article resolve the issue?