Last Modified Date: 24 Sep 2020
- Tableau Desktop
- SharePoint Lists
ResolutionMake sure that none of the table names in the SharePoint are greater than 127 characters.
Make sure there are no apostrophes in the password.
make sure that there's no block in the sign-on rule for the Office 365 Okta app while Tableau Desktop connect to SharePoint.
CauseThis 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.
Another root cause could be: there is a block in the sign-on rule for the Office 365 Okta app while Tableau Desktop connect to SharePoint.
Additional InformationTo 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...