Incremental refresh/ incremental load

Hi Anonymous ,

For incremental refresh to work efficiently, the Power Query queries that define the model tables must support query folding.

Query folding is the ability for a Power Query query to generate a single query statement that retrieves and transforms source data. This way, the filter conditions for incremental refresh are pushed down to the source system and only the relevant data is retrieved.

Not all data sources and transformations support query folding. For example, flat files, blobs, and web sources typically do not support query folding. Also, some transformations such as pivoting, unpivoting, merging, and appending may prevent query folding. Therefore, it is important to verify that your queries can be folded when using incremental refresh.

Power BI Desktop provides a query folding guidance feature that can help you check if your queries are foldable or not. It also suggests ways to improve your queries to achieve query folding. You can access this feature by clicking on the View tab in Power BI Desktop and then selecting Query Folding Guidance.

Refer to:

Incremental refresh & query folding | Microsoft Power BI Blog | Microsoft Power BI

Query folding - Power Query | Microsoft Learn

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

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