Issue
When you try to edit a data connection, the following message might appear:A data extract is active. To continue the operation it must be regenerated. Filters will be cleared. Would you like to continue?
Last Modified Date: 19 Dec 2019
Environment
- Tableau Desktop
- Extracts
Resolution
Option 1
If there is no need to add filters prior to creating the new extract, click OK when the message appears. A new extract will be created without filters.
Option 2
If the original extract included filters, and you would like to include the same filters on the new extract, add filters prior to editing the data connection:
- Prior to editing the connection, select Data > <data source name> > Extract > Remove, and then click OK.
- Edit the connection. For more information, see Connecting to Data and Editing Data Sources in Tableau Help.
- Select Data > <data source name> > Extract Data.
- In the Extract Data dialog box, add the desired filters, and then click Extract. For more information, see Creating an Extract in Tableau Help.
Cause
When you edit a data connection, Tableau re-creates the extract. If you had filters applied to the extract, these filters will be removed.The ability to select whether to keep, modify, or remove the filter, directly before extract is refreshed is not currently built into the product.
Additional Information
To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea: Add Filter Before Creating Extract When Modifying ConnectionDiscuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials