Last Modified Date: 22 Feb 2017
- Tableau Desktop
- MS SQL Server
Option 1:Use the Read uncommitted data option when creating the connection. The connection will default to the isolation levels set on the database.
Note: Your database administrator will still need to manage the isolation levels in order to ensure the desired result.
Option 2:Create a .tdc file. The following post from the Tableau Community may be helpful when creating this type of .tdc file: https://community.tableau.com/thread/166245
This solution also requires the database administrator to set the isolation levels in order to ensure the desired result.
Note: 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.
Additional InformationTableau may lock a table to keep the integrity of the data during long processes.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials