As far as I know there is no way to edit the extract filters that you set during the data extraction process once the .tde file is created and the extract is published to the server. I have tried doing it before and couldn't find a way. The 'Edit Data Source Filters' option which is for Data Source Filters is different from Extract Filters. You can refer
Let me know if you come across any solution.
Ravi, Thank you so much for answering my question. I would like to have a detailed discussion with you on this. I came to know that Extract Filters are different from Data source filters. I am thinking about recreating extract and will let you know if I found any thing other than that.
Sure, we can have further discussion on this.
Today I have recreated the entire extract, its very time taking and painstaking to load 60 week data by incremental addition.....
Although this is an older thread, I am adding more information about editing extract filters to help anyone else who comes across this in a search. Please note that all of my examples are borrowed from Tableau Desktop Professional and Server 9.2.6 although the features are similar on other not-too-distant versions.
It is possible to edit extract filters! Even if the extract has been published to Server and no local .TDE files are available.
First, as you are probably aware if you've found the related thread How do Data Source Filters affect Extracts?, Extract filters are not the same as Data Source filters. While data source filters have their uses, only an extract filter will restrict the quantity of data that is extracted initially and at every subsequent refresh, and possibly reduce extract size and refresh time as well. For this reason extract filters can be useful in managing server capacity for extracts, when not all records from a source system or file is necessary for daily use. Similarly, the "Hide All Unused Fields" option can be used to exclude unneeded dimensions and measures from an extract.
The initial process of applying extract filters is easy to access. When a user selects the "Extract Data" command, they are presented with a dialog that prompts them to "Add" a filter. The user can select the "Add" button to be presented with all of the available dimensions and measures in the data source, each with the familiar filtering options like inclusion, exclusion, and date range, just like in the filter shelf.
Once the extract has been created, however, these options are not as easily discoverable by the user. In order to update extract filters, select the "Edit Data Source" command to switch to the Data Source view. In the upper right corner of this view the message "Extract includes subset of data" will be displayed. If the user clicks on "Edit" they will be able to view all of the existing extract filters, and have the option to Add, Edit, or Remove these filters.
What if the extract has already been published to Server as a standalone data source? Just connect to the published data source on Tableau Server, select the "Create Local Copy" command to download a .TDSX file to local storage, then follow the instructions above. Once the local copy has been updated, then republish it to Server, making sure to use the original name as previously published so that it will overwrite the existing data source on server.
Hope that helps anyone who has encountered this confusing issue.