Article Note: This article is no longer actively maintained by Tableau. We continue to make it available because the information is still valuable, but some steps may vary due to product changes.
After downloading a fully refreshed extract from Tableau Server, you may notice that the file size of the extract appears to be larger than you had expected. The difference in file sizes between the published and downloaded versions of the extract depends on the number of calculations contained in the workbook and where the size of the workbook is being viewed.
Number of calculations
When full refreshes are performed on extracts on Tableau Server, calculated fields that are being used in the workbook are optimized to help improve performance. More specifically, Tableau moves your calculated fields into the extract, which then creates new measures that you do not see. These new measures contain pre-computed values so that your calculations do not have to be recomputed each time they are used. When extracts are optimized like this, the file size increases.
You may not be aware of the file size increase that occurs during a full extract refresh because it is not reflected until the workbook is downloaded. In other words, the file size of a workbook displayed in the
Workbooks detail section of Tableau Server only shows the size of the workbook when it was initially published. To determine the current size, you must download the workbook to your machine and check the size of the file, locally.
Alternate Search Terms:sizing, extract files, workbook files