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.

ajaybabuinturi's avatar
ajaybabuinturi
Super User
9 months ago

Hi powerbiexpert22,

 

The below resources are provided a handful information about Incremental Refresh by using SSMS(for backend process). However we need berify your BI report is doing incremental refresh or not, for this you need check Point No-5 whether the current month partition have receent date&time stamp or not from the 1st reource. 

 
 

 

Resource 1:   https://analytis.com/use-ssms-full-refresh-powerbi-incremental-refresh/ 

Resource 2:  https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla 

 

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.