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.
Last Modified Date: 27 Jan 2018
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.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials