Forum Discussion
Incremental refresh/ incremental load
Hi everyone,
I am trying to make a report with IBM DB2 database and hence, it does not support query folding. I want to confirm because I could not find documentation or tutorials on incremental refresh that addresses this doubt,
is incremental load compatible with queries that don't support query folding?
If yes, can anyone add some supporting URLs for reference etc.
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.
2 Replies
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.
Como actualizar incrementalmente en power BI desde una tabla de Microsoft Access?
