Friday, September 5, 2014

Using Tableau and Tableau Server with SQL Server Analysis Services

The following applies this situation: SSAS is installed on a machine not connected to a Domain. Tableau Server installed on a machine not connected to a Domain. Tableau Server users are set up in the local Tableau user database (not Domain user accounts). You want all users to be able to view data pulled from the SSAS instance without having to enter additional credentials beyond their Tableau Server creds.


If you want to use Tableau Server with SSAS cubes, you need to set up Tableau Server to be running under a machine account that has permissions to access the SSAS cube (on non-domain machines this means creating matching usernames/passwords on each machine). IN ADDITION, when you publish a Tableau workbook or data source to the Tableau Server you need to be running Tableau Desktop under a machine account that has permissions to access the SSAS cube. This is the only way you will see the option to have Tableau Server use the RunAs account when it connects to the SSAS cube.


If, from Tableau Desktop, you connected to the SSAS cube by typing in credentials, you will not see the RunAs authentication option when you publish the workbook or data source to Tableau Server (meaning your users cannot use the workbook or data source).


The following help articles, while useful, didn’t seem to address the above use case (not in its entirety anyways):


http://ift.tt/1lG2LVg


http://ift.tt/1pyOuEO


http://ift.tt/1lG2Jwp


http://ift.tt/1pyOsgc





No comments:

Post a Comment