1 of 1 people found this helpful
Hi Bhargava Reddy ,
No ,its not possible .What you are asking is like storing your data in tableau even when its not present in your data source .Try the incremental refresh for the first time ,what will happen ? Do you think it will store the previous state of having no data ? Similarly when you are changing the whole data incremental refresh will not work as you are thinking . If you want to get the snapshot of your data better append your data in a data source .
Let's suppose you are working on SQL . Today you store A = 20 and you are using select statement you will get A= 20 .Next day you overwrite A = 30 so now you will get 30 not 20 because you overwrite it .But instead of overwriting A if you would have append it like day 1 A= 20 and day 2 A= 30 and so on , you would have solved your problem .
Please mark it right and helpful if this serves your purpose so that others can also get benefited & also to close the thread.
yup thought so, was just curious if there is a work around. Thanks for helping me.