KNOWLEDGE BASE

Extract Refresh Unsuccessful When Using User Filters or Impersonation


Published: 07 Feb 2014
Last Modified Date: 04 Aug 2017

Issue

When you try to refresh an extract on Tableau Server, one or more of the following errors might occur:
  • Cannot evaluate user filter; no current user or group
  • An internal error occurred while establishing an impersonated database connection
  • Cannot establish an impersonated database connection when connected as a Tableau guest user

Environment

  • Tableau Server
  • Extracts
  • User filters
  • Impersonation

Resolution

For the error message "Cannot evaluate user filter.." 

If you would like to be able to refresh the extract while it is embedded in the workbook,
Republish the workbook and specify the thumbnail when publishing. If you publish using tabcmd, specify the option --thumbnail-username or --thumbnail-group. 

For the error messages "An internal error occurred while establishing an impersonated database connection" or "Cannot establish an impersonated database connection when connected as a Tableau guest user"

  1. Download the workbook and open in Tableau Desktop
  2. Publish the extract datasource to Tableau Server, replacing the datasource in the workbook with the published datasource. 
  3. Republish the workbook to Tableau Server. 

Cause

When trying to refresh a workbook which contains an extract and has user filters, Tableau Server may evaluate the user filter in order to generate the thumbnail.

OR 

The extract is joined to a live connection which uses impersonation, however an extract cannot be refreshed using impersonation. 
Did this article resolve the issue?