KNOWLEDGE BASE

TableauException: Operation timed out with Excel live connections


Published: 02 Jan 2018
Last Modified Date: 02 Jan 2018

Issue

On Tableau Desktop, an Excel file containing 3 sheets stored in a shared folder were published separately as 3 live data sources: Table1, Table2, and Table3. After creating a workbook connecting to Table1, Table2, and Table3, published to Tableau Server and clicking "Refresh", the following error may occur:

Unexpected Server Error
TableauException: Operation timed out.

Environment

  • Tableau Server 10.1.6
  • Excel

Resolution

The solution is to split the Excel file into 3 files (Table1.xlsx, Table2.xlsx, Table3.xlsx). Then republish all three data sources. 

Cause

Three live data sources were actually pointing to a single Excel file. That configuration caused file-locking.
Did this article resolve the issue?