Quicksight cannot use incremental refresh

[royyung]

you may refer to the discussion in another thread.

Incremental Refresh Limitations Question

@newQSUser - this dataset is built on a single MySQL data source though. I do know what you are describing is true when you have a cross-source dataset, incremental is not an option, which makes total sense.

Can try to put into 1 custom SQL and see if incremental refresh is available?