KNOWLEDGE BASE

Error "DataSourceException: No Tableau Server user found ... Unable to connect to the server" When Refreshing Extract-based Workbook


Published: 10 Jul 2014
Last Modified Date: 28 Sep 2017

Issue

When refreshing a workbook containing extract-based published data sources on Tableau Server or Tableau Online, the following error might occur:
 
com.tableausoftware.nativeapi.dll.DataSourceException: No Tableau Server user found.
class DataSourceException
Unable to connect to the server "<server name or IP address>". Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Server
  • Tableau Online
  • Data Server

Resolution

Update the Tableau Server data connection:

  1. Verify name or IP address of your Tableau Server.
  2. In Tableau Desktop, open the workbook.
  3. Right-click the data source name in the Data panel and select Tableau Data Server > Edit Server Site & Path.
  4. In the Edit Tableau Server Data Connection dialog box, click Change Sign In.
  5. Enter the appropriate server name or IP Address.
  6. Follow the remaining steps in the window and click OK.
  7. Republish the workbook with embedded password authentication. For more information, see Embedding Passwords and Authentication.
If the above solution does not resolve the issue, try the following steps (Requires Tableau Desktop): 

Step 1: Add the Data Source Again

  1. Download the workbook from Tableau Server and open with Tableau Desktop.
  2. Click on "Data" at the top of the screen.
  3. Click on "New Data Source".
  4. Click on "Tableau Server".
  5. From here, select the original source of the data source which is causing the error. 
  6. Click on your worksheet title. You should now see two data sources with the same name. The new one will have a number after it, for example "datasource(2)".

Step 2: Replace the Original Connection

  1. Right click on your original data source listed in the Data Pane (the first connection, the one that was not working), and select "Replace Data Source".
  2. Make sure the data source listed in the "Current" field is the original bad connection, and the data source in the replacement field is the fresh connection you just added. 
  3. Click "ok".
  4. Save the workbook.
  5. Close the workbook and reopen it.
  6. Right click on the data source in the Data Pane and hover over  "Tableau Data Server" and "Edit server and site path".
  7. From here, confirm that the server url listed is correct. If so, click "cancel".
  8. Publish this workbook with the new connection to Tableau Server and try to refresh it again. 

Cause

The Tableau Server name or IP Address has changed and published workbooks are configured for the old connection information or the workbook does not have credentials embedded.

Additional Information

If workbooks with embedded data sources are experiencing the issue, check that the Run-As user for Tableau Server has the correct permissions. See the Run As User in Tableau to learn more about how to set all appropriate Run As User permissions.
Did this article resolve the issue?