KNOWLEDGE BASE

Error: "Worksheet Unavailable. There was a problem connecting to "<Data Source Name>" data source." After Opening a Workbook


Published: 27 Sep 2016
Last Modified Date: 30 Dec 2016

Issue

When opening a workbook in Tableau Desktop with a published data source, the following error might occur:
"Worksheet Unavailable, There was a problem connecting to "<Data Source Name>" data source."
 

Environment

  • Tableau Desktop 10.0
  • Tableau Server 10.0
  • Proxy and Firewall

Resolution

  1. If Tableau Server is behind a proxy, ensure that the 'gateway.public.host name' is set correctly. For more information, see: Configuring Proxies for Tableau Server
  2. If the above information is correct, and the issue continues, try the following:
    • Publishing the data source again.
    • Right click on Data Sources > Tableau Data Server > Edit server and site path > Enter the expected Tableau Server site name.

Cause

This error might occur for following reasons: 
  1. The " gateway.public. host name " was not updated when Tableau Server was upgraded. 
  2. Proxies have been known to cause issues where a Tableau Server address will point back to localhost, or the Tableau Server machine name, rather than the site name.
Did this article resolve the issue?