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: 23 Jan 2020


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."


  • Tableau Desktop
  • Tableau Server
  • Proxy and Firewall


  1. If Tableau Server is behind a proxy, ensure that the ' 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.
    • If there are many data sources affected by this issue, using REST API to write scripts may allow automation of the above process. See Update Data Source Connection for more information. 

      The Developer Portal in the Community is the best resource for assistance in writing REST API scripts.


This error might occur for the 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?