That AD option is referencing the user authenticating automatically with the Tableau Server, not with data sources. When a data source is published to Tableau Server, the authentication can be set to "prompt user" (as it sounds like it is now) so that each user requesting the data must enter their credentials or can be set to use "embedded credentials" so that the person's credentials who created the data source in Tableau Desktop and published to Tableau Server are used to refresh the data source. Check out this article: Online Help: Embed Credentials to Streamline Signing In to a Published Workbook
Thank you for your reply.
I learned about "prompt user" and "embedded credentials".
I use ssas roles to control different AD users can access different data.
"embedded credentials" make everyone get the same data like publisher. That's not what I want.
"prompt user" can make different user get their own data, but it always prompt the publisher's username, everyone have to change the username.
Is it possible to prompt users their own username?
Thank you for your help.
If the desire is to have all users see a single Viz that changes based on what data is available to them, you may be able to use User Filtering in the workbook, check out this article: User Filtering If you wanted the data source itself to pass the credentials to the database server, that functionality is not currently built into the Tableau Server application.
Hope this helps!
I will try "User Filtering"
Is there any plan to add the functionality that automatically use current AD user's credential to connect to the SSAS?
Glad to hear that might be helpful. I don't know of any plans to update that functionality, but I'm not aware of all planned features for new releases. I know Tableau 10 is coming out soon and may have some additional options but you could always submit this to the Ideas section of the Community to get the attention of product managers.