Can I disable load to speed things up?

[925stuart]

Hi,

I've been using dataset.xls to build visuals.  dataset.xls is hitting Excel's technical limit so I'm now directing new data to a new file dataset2024.xls.  I'm appending dataset2024.xls to dataset.xls.  Given that dataset.xls is now going to be static, i.e. no more new data will be added to it, can I disable load to speed things up?

[mussaenda]

Hi @925stuart ,

you can uncheck the include in report refresh the data that is static.

[925stuart]

Since I'm appending dataset2024.xls to dataset.xls, would disabling refresh of dataset.xls also disable the refresh of dataset2024.xls?

[mussaenda]

before appending, exclude the report refresh on the dataset that is static before appending it to your 2024 data. Make sure that you'll be appending it to your 2024 data and not the other way around.

[925stuart]

It seems like I should exclude in report refresh instead?