Incremental Refresh Not Loading Archive Partition

Hi , genehsu 

According to your descrioption, the incremental refresh dose not work in you Power BI Service.

First , To be clear, Incremental refresh will not take effect on Power BI Desktop, it will only show the data you filtered in Power Quwey Editor, and will only work after you have configured the Incremental refresh policy correctly and published to the Power BI Service.

The first refresh on Power BI Service is a sequential full refresh, which creates the corresponding partition, and refreshes the historical partition and the incremental partition, and then the subsequent refresh will only refresh the incremental partition.

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

Second, if our incremental refresh does not take effect on Power Bi Service, we need to check if there are steps in Power BI Query that prevent the query from collapsing, causing the incremental refresh to fail.

At the same time, you also need whether your configuration process is the same as described on the official website, and the parameters of the variables must be consistent here, because its underlying logic is to override the values of these parameters on the Power Bi Service, and then pass them to our underlying data source to obtain the corresponding data.

The steps you can refer to :
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

And you can also use the SSMS to connect the dataset to check the incremental refresh partion.SSMS can be used to view and manage partitions created by the application of incremental refresh policies. You can check the incremental refresh can work?

For more information, you can refer to:
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