Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Incremental refresh behaviour

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 !

Super User
Super User

@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 -

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

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors