I have a twb that is 3,325kb. I packaged it and now it is 359,469kb. I have already gone thru and hidden columns I don't need from the raw sources and anything that I can change the geographic to none I have done. Is there a way to decrease the size that I am missing. Everything in the workbook views and sources I need. I was thinking if I packaged it and extracted the workbook and then published the extracted workbook would that work? Would everything still work with the extracted workbook? Is there a downside to extracting your workbook? I have to refresh it monthly so does this mean I always have to work from the twb to update it all and then create a new twbx and then publish the extracted workbook again?
This is still not very easy to follow but partially helps.
And this attachment illustrate the separate publish of data source and workbook.
The behavior is different when you join the data and I am still keeping learning as well.