Incremental Refresh and Query Folding

Hi Anonymous ,

Based on the knowledge, try to specify a short date/time period in the RangeStart and RangeEnd parameters that include no more than a few thousand rows. If the load of filtered data from the data source to the model takes a long time and is process intensive, it likely means the query isn't being folded.

You can also view the following documents to learn more information.

Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn

Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

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