Introduction
Introduced in Tableau 2022.4, selective replacing of data sources allows you to replace data source on a selected worksheet in your workbook rather than replacing all worksheets and dashboards in your workbook.
When you replace data source – Tableau simply redirects all fields used in the data source and maps them to the corresponding fields in the new data source.
You can read more about replacing data sources in Tableau
In Tableau 2022.4 onward, replacing data source dialogue box has an additional checkbox that allows you to customize how you would like to replace your Tableau data source –> you can replace the data source in the current worksheet only or in the entire workbook.
To replace data source >> Go to >> Data menu >> Replace Data Source…
Alternatively, Right-click on data connection on the data pane >> Replace Data Source….
(On the dialogue box – see above, choose the current data and replacement, and check the box ‘Replace current worksheet only’ if you wish to replace data source on a single worksheet – if your goal is to replace data source in the entire workbook leave this checkbox unchecked)
I hope this short article was helpful to you. If you wish to receive more Tableau tips and tricks, kindly join our mailing list by subscribing below.
If you like the work we do and would like to work with us, drop us an email on our contacts page and we’ll reach out!
Thank you for reading!
