Hey Thomas -
What version of Desktop and Server are you using?
When you add a filter to context, we actually (not always, but mostly) create a temporary table at the data source and store the results of the filtering in that table. It sounds like that temp table isn't getting cleaned up properly.
Also, what database are you using as your source? This might be fun to try and reproduce if I one available.
I have been testing the issue using Tableau Server and Desktop 7, but i recall seeing a similar problem with Tableau 6.
I am using a SQL Server datasource with and witout extracts.
I tried with a text file and only 5 rows of data (one column called username) and the behavior was exactly the same.
I think this is easy to reproduce if you have Tableau Server and a way to license a few interactor users on it.
Hi Thomas, did you find any better solution for this?
This still appears to be an issue in Version 8.3.4. We are experiencing the same issue, please share if you were able to find any resolution.
Thomas - Now I am working on same kind of requirement... if you don't mind can you share that file or share if u have document
This may be different than your exact situation, as I am using Active Directory and a security table join to determine user access to data. I noticed that the once you publish to Tableau server, the 'filter as user' stops working locally in Tableau Desktop, since it always passes in the user that is "logged into" the server within tableau desktop. Add a calculated field that is username() to test it out to your result grid. Now in my case I used calculated field (username = username()) and added a filter to the data source where that equals true. I did NOT create a 'user' filter, or add it to the view at all. it is purely in the data source. I had a data table that had a key mapping between the data/category ID and the user ID, such as department, region, etc. You also need to be logged into the computer as user A/B if you are using Active Directory to get the correct username to pass through to the filter in tableau server.