Yes, admins will have server admin privileges. The goal is to store highly sensitive information in Tableau that should only be accessed by certain people. There will be folks who have server admin privileges who I don't want accessing this information.
I think USER FILTER is best for you.
I tested for a site for which I am Site Admin.
Just created a calculation as below and drag it to filter saying 'True'
Even being the Admin of the site I could not see since I gave access to some other user.
Note: User Name is your Login
When I access the workbook it will come as a Blank since my CEC login is not matching to 'yourusername'
Please set this as CORRECT/HELPFUL if it really helped you so that it can help others as well.
What if you do not want server admins to see your data?
- Security requirement: You are Ok for admin to see your project name, workbook names, data source names, but when admins click your workbooks, you do not want admins to see any data of your workbooks. Not only that, you also want to make sure that server admins have no way to see the data even admin can edit your workbook or change your workbook permissions or change your data source permissions
- Solution: Your source data has to be in the database that your team controls with password. When you publish workbook, use live connections only (no extracts) and do not embed the password.
- How it works? Tableau server users will be asked to enter your database password before any data can be queried from your database. Server admins will not have your database password although admins can still see your workbook name. Even admin can download the workbook, which is the .twb only, admin still can't see any of your data which is a live connection to your data source with password required.
ps. Ritesh's proposal works but admins can change your datasource/workbook filter - which will by-pass your access control.