Have you ever found yourself in a situation where you needed to change the data source for a specific worksheet in your Tableau workbook but didn’t want to affect the rest of your analysis? If so, you’ll be happy to know that Tableau 2022 has just introduced a game-changing feature that allows you to do just that – replace data sources on a worksheet level. This new feature is inspired by the Tableau community and will be incredibly useful for anyone working with data analysis in real-time scenarios.

Basically, this feature lets you change the data source for a specific worksheet without affecting the other worksheets in your workbook. All you need to do is have two compatible data sources with the same structure (columns and data types), and you can replace the data source on a worksheet level.

To do this, open the worksheet you want to replace the data source for, click on the Data Tab, and select “Replace Data Source.”

A new window “Replace Data Source’ opens.  Select the current and the replacement data source you want to use, check the box ‘Replace current worksheet only” and click “OK.”

Tableau will automatically update the worksheet with the new data source, and all of your visualizations and calculations will be based on the new data. You can confirm with a blue check mark in front of the data source used.

In real-time scenarios, this feature can be extremely useful. For example, if you are working with data from a streaming source, the data can change every second, and you need to update your visualizations and calculations accordingly. You can easily switch between data sources without having to recreate your visualizations and calculations from scratch, use different data sources for different worksheets, and ensure that your visualizations and calculations are always based on the most up-to-date data.

You can also compare data from different sources by easily switching between them and comparing them side-by-side.
Overall, this new feature is a significant enhancement to Tableau 2022 that will make your life easier and improve your data analysis. Try it out and see how it can benefit you in your work!

Seema Keswani
Author: Seema Keswani