Incremental refresh behaviour

[bboy0009]

Hi guys,

I'm doing some tests to understand how the incremental refresh works and there is something that I struggle to understand :

I have configured my power query in order to retrieve ONLY data of the day before and I set up the incremental refresh like below 

Yesterday (25/04), I refreshed the PBIX so I had the data of 24/04. After, I published it and after checking the report in Service, the dataset had the same data. Today (26/04), the incremental refresh happened well and I noticed that the data of 24/04 has been deleted and there is only data of 25/04. I expected to see data of these 2 days. 

Is it normal ? 

Thank you in advance !

[amitchandak]

@bboy0009 , Yes, you should see 2 days/ 2 years of data of data.

Re-run the Refresh manually and check for any error or logic issue.

Make sure the dates/data types are correctly defined

Still does not work log an issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

[bboy0009]

I have re-run the refresh manually and the result is the same