Last Modified Date: 20 Apr 2018
- Open an affected workbook in Tableau Desktop.
- Right-click the data source in the 'Data' pane on the upper left hand side and select Create local copy.
- Use the Replace data source option so that the local copy is being used and close the published Tableau Server data source.
- Ensure all parameters are correct and make any necessary adjustments.
- Right-click the local copy of the data source and re-publish it to Tableau Server, overwriting the old one.
- Connect to the data source on Tableau Server and replace the data sources again, so that the published data source is in use.
- Close the local copy of the data source by right-clicking it and choosing Close.
- Save the workbook.
CauseThe internal names of the parameters do not match between the data source and the local workbook, therefore Tableau Desktop creates a copy for each mismatched parameter between the data source and the local workbook, resulting in duplicated parameters.
Additional InformationWhen using Tableau Desktop 9.2, please note that there was an issue when creating local copies of published data sources. This issue was addressed in version 9.2.6, for more information, see Error "An unexpected error occurred and the operation could not be completed" Creating Local Copy of Published Data Source.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials