Incremental refresh taking more time for refresh

Hi  Vallirajap ,

The time taken for incremental refresh could be related to the complexity of the model and the process of query folding. If the data source doesn’t support query folding, it could lead to longer refresh times.

If there’s a mismatch in data types between the RangeStart and RangeEnd parameters and the date column in your table, it could prevent the query from folding, leading to longer refresh times.Please ensure that the date/time column for the incremental refresh table is of Date/Time data type.

Also,If your table contains a large number of rows, a refresh can take a long time and consume a significant amount of resources.

You can use the Performance Analyzer in Power BI to measure the processing time required to update report elements.

For original post：

Power BI Incremental Refresh taking more time than... - Microsoft Fabric Community

Re: Power BI Incremental Refresh taking more time ... - Microsoft Fabric Community

Best regards.
Community Support Team_Caitlyn

Whenever you make structural (meta data) changes to your PBIX and publish that to the workspace it will reset the incremental refresh. All partitions will be removed and a single partition will be filled for the query where you have incremental refresh configured.  On the NEXT refresh your partitions will be recreated and filled according to your rules. On the NEXT refresh only your "hot"  partition will be refreshed.

To avoid that you either need to refrain from making meta data changes, or you need to use tools like ALM Toolkit to propagate the meta data changes without re-initializing the partitions.