Issue
When refreshing an extract on Server, an error is occurring stating:
DataServiceFailure There was an error with the data source xx. Verify that the data source is configured correctly.
Note: The Test connection to the data source succeeds.
Last Modified Date: 08 Jul 2022
Environment
- Tableau Server
- Windows Server 2012
Resolution
- Download the published workbook and open in Tableau Desktop
- Navigate to the Data source Tab, and check, if prompt to Tableau Server sign in appears ( denoting that the extract was created from a Server published data source)
- Add a new copy of data source to the workbook, and create the extract.
- Replace the existing connection, to refer to the newly created extract
- Closed the old corrupted data source.
- Re-Publish the workbook, with the new extracted data source.
Cause
The embedded extract, is created by extracting a published data source, which does not exist any more. So the extract needs to be created by referring to the actual data source ( SQL Server in this case)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