incremental refresh not refreshing data on daily basis

Hi, dd96 

According to your description, you said that your incremental refresh did not refresh the data every day.
Based on your screenshots, you can see that your strategy is to retain data for 1 year and refresh data for only one day.
But you only refresh on Thursdays of every week.
For data configured for refresh for one day, you need to configure a scheduled refresh once a day. For example, if you only refresh on Thursday, you will only refresh the data for that day.
For the underlying logic of incremental refresh of Power BI Service, it is to replace the two variables to generate corresponding SQL statements to query the underlying data source, you can use SSMS to connect your dataset and then check whether the created partition meets your needs.

 

For more information, you can refer to :
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly