SharePoint List Extract Missing Records

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.

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.