SharePoint List Extract Missing Records

Published: 12 Dec 2017
Last Modified Date: 03 Jan 2018


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