Dataset cannot configure incremental refresh

[zhangjie]

My dataset does not provide incremental refresh function, and I want to know why.

1. My data source is Amazon RDS MySQL;
2. I have provided the corresponding timestamp data;
   
   
3. I am an administrator and I am using QuickSight Enterprise Edition;
4. I didn’t find any changes to the incremental update feature in the changelog: What's New / Blog - Amazon QuickSight Community

[Xclipse]

Hi @zhangjie, thanks for the context and details. The incremental refresh option is available only if the dataset consists of one single table or one single query, i.e. if you join multiple tables, you have to write the join as one single query.

Here are several resources that maybe of help.

Incremental Refresh Limitations Question

Hi, I’m trying to understand how incremental dataset refreshes work. We have the enterprise edition, and I’m trying to understand what criteria needs to be true for incremental to be displayed as an option on a dataset. In my situation, I have multiple datasets that are set up as SPICE storage and use the same Data Source type (MySQL RDS instance). In some cases, I am able to configure incremental refresh on dataset, but in other cases the only option shown to me is a full dataset refresh. I …

Quicksight cannot use incremental refresh

We have created a dataset, but we can not choose refresh type. [image]

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply).

[Xclipse]

Hi @zhangjie, if the issue still persists, I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!