Forum Discussion
Working with big database
To reduce your file size, you can do the following:
1. In query editor, right click on the queries that are appended and uncheck Enable Load, so you don't load your data twice. They will still be refreshed but not loaded. Also get rid of any columns and rows you don't need, especially columns with high granularity.
2. If available, you can set up incremental refresh to reduce refresh time significantly.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Yes. You should also uncheck 2020, assuming you appended all three tables into a new query. If you appended into the 2020 query, then you need to keep load enabled. Are there high granularity tables you can remove/not load? How big is your file size after that?
Regards,
Pat
Thank you mahoneypat after unchecking unable load in all the tables, my file size was considerably reduced. Thank you for the advice!!