Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
9 months ago
Solved

incremental refresh stop

i  defined 12 months period to retain historical data and 1 month period for refreshing incremental data while setting up the refresh policy i gave the range start and range end parameters values fr...
Need Help
  • ajaybabuinturi's avatar
    ajaybabuinturi
    9 months ago

    Hi powerbiexpert22,

    I am sure whatever the dates you provided in the PBI desktop application that doesn't effect on incremental refresh. Those dates are just development purpose. 

     

    I would suggest you that please check once in the SSMS how the partions are working and latest date&time stamp, in this way you will came to know whether the incremental refresh is updating data or not.

     

    I hope you can able to see 12 partitions for 12 months archived data(from 1/11/2024 to 31/10/2025) and 1 month(1/11/2025 to 30/11/2025) for data refresh.

     

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

sergej_og's avatar
sergej_og
Super User
9 months ago

Hey powerbiexpert22 ,
I thought so.
I think you still have a typo there...."values from 01-Oct-2025 until 30-Sep 2025", makes less sense. Oct 2025 is bigger that Sept 2025.

But I think the issue is the same. You want to have the refresh until 30-Sep-2025. Ok, but we are now in Nov-2025.
Your data is not going to be refreshed because Sep-2025 is past.
What do you think?

Maybe I don't get your point completely.

Can you paste your incr. refresh setup for the tabel pls.

Regards