Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bboy0009
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 

bboy0009_2-1682500855009.png

 

 

bboy0009_1-1682500381106.png

 

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 !

2 REPLIES 2
amitchandak
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 - https://community.powerbi.com/t5/Issues/idb-p/Issues

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.