I work with an extract that is basically one huge table of transactional data, plus 3 dimensions tables, that are much smaller.
Embracing the value of having this simple star schema, at the database level, updating a dimension does not imply to update the whole transactional data set...
But when in Tableau, I don't know how to refresh only my dimension tables in my extract.
So when a simple dimension changes, I have to refresh the whole extract, which takes a lot more time.
Do you know if/how it's possible to only refresh one table in a multiple table extract ?
Thanks a lot !
I don't think it is possible in Tableau data extract. ( Like Analysis services cube - Just updated data refresh )
However you can try to create a work around using Incremental Refreshes. Optimizing Incremental Refreshes | Tableau Software
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...