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.

v-ssriganesh's avatar
v-ssriganesh
Community Support
9 months ago

Hi powerbiexpert22,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to ajaybabuinturi & sergej_og for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.