KNOWLEDGE BASE

Unable to Impersonate with Microsoft Analysis Services Data Source


Published: 07 Apr 2014
Last Modified Date: 16 Jan 2020

Issue

You cannot impersonate as Run As User when connected to a Microsoft Analysis Services data source.

Environment

  • Tableau Server
  • Microsoft Analysis Services

Resolution

Option 1

Enable delegation with Kerberos through the steps provided at Enable Kerberos Delegation in Tableau Help and  Enabling Kerberos Delegation for MSAS in the Tableau Online Community. 

Option 2

When connecting to the data source in Tableau Desktop, select the Use a specific username and password option, and then republish the workbook to Tableau Server. This will allow users to enter their own Active Directory credentials when accessing views on Tableau Server and edit the workbook layout in Tableau Server, without removing the filter that dictates what data the user has permissions to see. 

Option 3

In Tableau Desktop, add user filters to the workbook, and then republish the workbook to Tableau Server. For more information, see the following topics and articles: Note: Users with web authoring permissions might be able to remove user filters. To fully secure the data, see Restrict Access at the Data Row Level in Tableau Help.

Cause

The ability to use Impersonation with a Microsoft Analysis Services data source is not currently available in Tableau Server. Unless the Use a specific username and password option is selected when connecting to the data source, Tableau Server will use the Run As User account credentials. 
Did this article resolve the issue?