KNOWLEDGE BASE

Tableau Desktop Becomes Unresponsive When Connecting to an Specific Table


Published: 10 May 2016
Last Modified Date: 16 May 2016

Issue

When connecting to a table that contains self-referencing foreign keys of the following types, Tableau Desktop might become unresponsive: 
 
ALTER TABLE [SchemaName].[TableName] WITH CHECK ADD 
CONSTRAINT [FK_TableName_TableName] FOREIGN KEY([Id]) 
REFERENCES [SchemaName].[TableName] ([Id]) 

Environment

Tableau Desktop

Resolution

  1. Remove the self-referencing key from the table.
  2. Create a view and connect to the table directly. 

Cause

This behavior is related to a known issue that is currently under investigation.
Did this article resolve the issue?