SPICE dataset refresh error - "The lookback window column is not valid in your dataset."

Question & Answer
, ,
1

Hello, I am attempting to run an incremental refresh of a dataset and am receiving the error below:

The incremental refresh failed to run due to a problem with the configuration: [The lookback window column is not valid in your dataset.] Please correct this and re-run a full refresh.

This dataset refresh has been running without issue for months and this error is new in the past couple of weeks. The lookback window column is in date format.

2

Hi @Gaelle

Welcome to QuickSight Community .

Was there any recent changes done on the dataset and incremental refresh failing? . You can check if there is any recent changes under publishing history view.

image

Could you please open the dataset and ensure lookback date column is still available and ensure there is no join with any other datasets.

Thanks
VInod

3

Hi @Gaelle Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.

4

@Gaelle
Since we have not received a response from you on this question, we are going to archive the question. If you still need this question answered, please create a new question topic.