Hi,
I have a tableau workbook with 11 data sources and the workbook is published on the Tableau Server to be viewed by users.
The tableau workbook is scheduled for data refresh on monthly basis, in case if the refresh fails i have to manually download the workbook from server and initiate the fresh extract for all 11 data sources from scratch.
By Scratch i mean if the report has 24 months data plus last month new data also to be added then i have to extract all 25 months data which takes a lot of time.
I wanted to know is there any other way of extracting data in which i can only be able to extract latest months data and append it to the last 24 months existing data.
Thankyou for help!
Abhishek
Trying to answer all your questions:-
The SQl query takes more than 10-12 hours as there are more than 18lakh records and the DWH server shuts down late night because of which the connection breaks and the query fails.
I need all 11 Data Sources as this workbook contains many dashboards, Yes all the data sources hit the same database, No these data sources cannot be embedded at the moment.
I tried to find the incremental refresh option but i did not see one, attached the screenshot of my tableau workbook, currently i am using tableau 9.2 desktop.
I wanted to know if there is something which can be done to save the time and effort?
Regards
Abhishek
