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.
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).