Thursday, July 30, 2015

Tableau + Kerberos + SSAS = I Love IT

If you think all is already in please, still failed check:
1. Published Workbook, Data source authentication - Use Server Run as = Tableau Server service account need to be registered in Cube to access
2. Published Workbook, Data source authentication - Viewer Credential = User must have their account registered in Cube to access
 If Failed, check:

  •  Does SSAS server has SPN registered in AD? 
  •  If it does, Is Kerberos Constrained Delegation has been set? 
 POWERSHELL MAGIC:

ipmo ActiveDirectory Get-ADUser -Properties msDS-AllowedToDelegateTo | select -ExpandProperty msDS-AllowedToDelegateTo 
  •  Is user has account registered in SSAS cube?

 If all those failed, support@tableau.com is your best friend

No comments:

Post a Comment