1 of 1 people found this helpful
The technique you want to use does work against SSAS. Use the "Use a specific username and password" option and plug in a Windows domain username and password.
You may not specify a domain username & password in the same way against SQL Server, however. This is by design. If you feel this would be useful to the larger community, feel free to post a feature request in our "Ideas" forum - the community will then vote it "up" or "down".
Thanks a lot for answering that fast!
So how can I use a Microsoft SQL server connection within the tableau server? Run the server not through a local but a windows domain account, which is allowed to access the SQL server?
You could do any of the following:
· Enable Impersonation on Tableau Server so that domain credentials of the logged-in user are automatically passed through to SQL Server
· Use an account which can access any data in the SQL Server and then enable row-level security in Tableau to limit the rows users can see based on their Tableau account
· Prompt users to login to SQL Server before the report runs