Forum Discussion
Incremental Refresh date refresh
Hi All,
I implemented Incremental Refresh for my report but I have a question regarding this incremental refresh.
So let's say I implement the incremental refresh for Table A with below conditions.
I publish this report to Power BI Service and do the initial refresh.
And I have these data based on Modified date (for now the date modified and date created is the same)
Today's date is 24th November 2021, but the one that refreshed on my Power BI Service is only 21st November 2021.
The data from 22nd November 2021 is not inside, is there something wrong with the setting of my incremental refresh?
As my understanding the 7 days in my setting it will check last 7 days based on today's date. Please let me know if my understanding is wrong.
Any answer will be very appreciated! Thank you!
6 Replies
conniedevina , I think, 7 Days of data from the date of refresh will be refreshed.
Please check do you data in core system for 22nd Nov based on created date
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
Hi amitchandak ,
Thanks for your reply! so I'm using sharepoint folder here and yes the date created is 22nd November 2021.
I'm not sure why it's not included in my incremental refresh per today's date.
Is RangeStart and RangeEnd will change automatically based on the today's date?
conniedevina , RangeStart, and RangeEnd what we create in power Query are for the initial Range?
for incremental, this 7 days should work. can share settings for those two parameters
