Last Modified Date: 27 Nov 2020
- Tableau Desktop
- MS SQL Server
Option 1Create and refresh separate extracts (per table) and use data blending in the workbook. This option will allow each of the extracts to be refreshed incrementally independent of the others and it does not require any changes on the database side to implement. When used in a workbook together, the tables can be blended on date fields or some other non-unique field that they have in common. Additionally, each data sources can be published and used independently.
Option 2Work with your database administrator or your SQL Server administrator to create a a view in SQL Server that combines the three tables and provides its own unique key. This view would just be connected like any other table and an incremental extract can be made on the key of the view instead of those in the original tables.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials