SharePoint List Extract Missing Records

Published: 12 Dec 2017
Last Modified Date: 04 Nov 2019


When connecting to a SharePoint List, the extract may have fewer rows in the data set than are present. Accessing the affected list in a web browser will show all data.


  • Tableau Desktop 
  • SharePoint Lists


Make sure that the Default view for the table in question is not limited or filtered. Tableau Extracts will only contain the rows and values present in the table's Default view.


Due to a limitation in the CData ODBC driver, Tableau can only connect to the Default view of a given list. Some organizations establish filtering on their Default view without realizing this will limit the data Tableau Desktop can access.

Additional Information

For more information about editing a view and making a public view the default view in SharePoint, see: Note: The information above is related to a third-party product. Please note that while we make every effort to keep references to third-party content accurate and up to date, the information we provide here might change without notice as the third-party product changes.

Discuss this article... Feedback Forum
Did this article resolve the issue?