Forum Discussion

conniedevina's avatar
conniedevina
Helper I
4 years ago

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....
Need Help
conniedevina's avatar
conniedevina
Helper I
4 years ago

I'm just refreshed again today (25th Nov 2021) 

And my 22nd data also not inside.. is it because I put the RangeEnd parameter to 22nd Nov 2021 12:00:00 AM? while I upload the data is more than 12:00:00 AM..

And I tried to upload the data at 24th Nov 2021 also it seems ignored by the refresh.. the refresh only until 21st Nov 2021.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi conniedevina ,

 

Your understanding of storage and refresh date settings is correct.

And according to this document, the RangeStart and RangeEnd parameters only implement on first refresh.

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#:~:text=When%20initially%20configuring,for%20each%20row. 

When initially configuring incremental refresh in Power BI Desktop, the parameters are used to filter only a small period of data to be loaded into the model. When published to the service, with the first refresh operation, the service creates incremental refresh and historical partitions based on incremental refresh policy settings, and then overrides the parameter values to filter and query data for each partition based on date/time values for each row.

The options that affect the refresh process are detect-data-changes and only-refresh-complete-days . Please check if your situation is related to these two options.

 

Best Regards,

Jay