When I edit a published dataset, it automatically triggers a full refresh, causing all dashboards using that dataset to go blank until the refresh completes. I’m looking for solutions to achieve either:
Option A: Disable automatic refresh after editing - in this way I can schedule separate refresh (e.g. in 1am)
Option B: Refresh a staging copy of the dataset (assuming all columns in production dataset are covered) and swap it with production once ready w/o impacting analysis and dashboard performance
Hi @chcccchiii and welcome to the Quick Community!
Unfortunately, option A is not possible. After publishing a dataset that you made edits to will always result in a refresh. However, option b might be possible if you create a duplicate of your dataset. You will have to manage both datasets separately but technically you can make edits in one and have the unaffected one be the one connected to your dashboard, then swap them out when you’re ready.
Hi @JacobR thanks for your reply - is there a way to override dataset by another post-edit with refreshed spice one? I tried but the original one remains the same and all data hasn’t been updated.
If I am understanding what you are saying correctly, no secondary edits will override a dataset’s refresh until the initial edit’s refresh is completed. Once you make edits, the dataset will start a refresh and you can continue to make edits to the dataset, but the dataset has to carry out the refreshes in a sequential basis.