KNOWLEDGE BASE

SharePoint List Extract Missing Records


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

Issue

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.

Environment

  • Tableau Desktop 
  • SharePoint Lists

Resolution

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.

Cause

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?