Incremental refresh doesn't update with the all data into my dataset

Question & Answer
1

Dear AWS QuickSight Team,

I hope this message finds you well. I am currently working with a dataset that has been constructed using the SalesLeads table, Sales table, and SalesAttribution table from a Postgres database. The SalesAttribution table essentially establishes the relationship between SalesLeads and Sales, determining whether a Sale should be attributed to a specific Sales Lead.

In order to keep the dataset up to date, I have configured an incremental refresh on a daily basis with a window size of 1 day. This approach is intended to capture all the updates that have taken place during the previous day.

However, I am encountering an issue where the dataset is not being fully updated with the inclusion of new records. This comprehensive update seems to occur only when I manually initiate a Full refresh.

I appreciate any insights or guidance you can provide to help me resolve this matter effectively.

Thank you for your assistance.

ClosedAt is a DateTime column in the SalesLeads table
image

Best regards,
Maor.

2

Hello @maorhevron1 !

Was this the incremental refresh working as expected prior to this or was this your first time using it? Also, what is the frequency that you set for the refresh before you chose the window size?

3

First time using it.
I set it to run on a daily basis.

image
image2148×872 109 KB

4

Hello @maorhevron1 !

The incremental refresh requires a full refresh when you first configure it. Did the dataset refresh correctly today or did it still drop rows?