5 Replies Latest reply on May 23, 2019 3:17 AM by Waqqas Awan

    Bad Connection: Tableau could not connect to the data source 2019.1.0

    Andrew Bickert

      Hello everyone,

      We recently upgraded to 2019.1.0 on Server and desktop. Everything went without a hitch with the exception of workbooks downloaded to Desktop from Server (Via the Server > Open Workbook tab in Tableau Desktop). We are unable to open up the Data Source Tab and receive the following error when doing so:

       

      Bad Connection: Tableau could not connect to the data
      source.

      Error: Unable to connect to this Tableau Server
      data source.

      HTTP 404: <?xml version='1.0'
      encoding='utf-8' ?><resource-not-found/>

      Unable to connect to the server "tableauservername".
      Check that the server is running and that you have access privileges to the
      requested database.

       

       

      This prompted me to go into the XML file and look at the underlying xml base information. It appears that when we are connecting to workbooks that are connected to a published data source, the repository location and xml base is being redirected to localhost instead of the hostname of the server:

      <workbook source-build='2019.1.0 (20191.19.0213.2333)' source-platform='win' version='18.1' xml:base='http://localhost:8264' xmlns:user='http://www.tableausoftware.com/xml/user'>

      should be

      <workbook source-build='2019.1.0 (20191.19.0213.2333)' source-platform='win' version='18.1' xml:base='https://tableauservername.com' xmlns:user='http://www.tableausoftware.com/xml/user'>

       

      Was wondering if anyone else has had this issue?

       

      The only way I have been able to get around it is either editing the workbooks on the server or going through and updating all of the localhost references to the hostname of the server and update the associated connections:

      ie:

      <connection channel='http' class='sqlproxy' dbname='***DBNAME***' directory='dataserver' port='80' server='localhost:8264' server-oauth='' username='' workgroup-auth-mode='prompt'>

      would become

      <connection channel='http' class='sqlproxy' dbname='***DBNAME***' directory='/dataserver' port='443' server='tableauservername.com' server-oauth='' username='' workgroup-auth-mode='prompt'>

       

      final comments:

      Upgrade was on Windows Server 2016 from 2018.2.1 to 2019.1.0 (Pre TSM to TSM). Data Sources were .hyper before hand so did not pursue the 2019.1 server not reading TDE sources.

       

      Appreciate any comments or insights,

       

      Andrew

       

      Error with Data Source:

       

      Very Helpful error: