KNOWLEDGE BASE

No Tables Displayed When Connecting to SharePoint Lists


Published: 31 May 2017
Last Modified Date: 17 Jul 2020

Issue

When attempting to connect to SharePoint Lists, the connection is established but no lists or tables are displayed on the Data Source tab.

Environment

  • Tableau Desktop
  • SharePoint Lists

Resolution

Make sure that none of the table names in the SharePoint are greater than 127 characters.

Also make sure there are no apostrophes in the password. 

Cause

This is a limitation of the CData SharePoint driver. It will not provide the list of tables if any of them have a name that is longer than 127 characters.

Additional Information

To find the table name that is preventing the list of tables from loading use the attached TDC file. You will need to update YourUserName to your username for the cdata.log file to be written.

​This .tdc file will create a log file from the CData driver itself. Open the CData log in a text editor and search for "SQL_ERROR[HY000]: SQLTables The length of tablename". This will show the name of the table that caused the issue. There may be more than one table with too long of a name, but only the first one that triggers this error will be shown in the log.

Important: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files.




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