Incremental Refresh and Query Folding

[ShahidYumeen]

Hi,
I am working on a project and was wondering if i could implement incremental refresh for my dashboards in powerBI. However i came to know that Incremental Refresh doesnt works with Non-foldable queries. When i checked mine, the "view native query" is greyed out for all the queries in "Applied Steps" including the first one "Source". 

Also i am getting this error when i implement incremental refresh on one of the tables

Please help me on this as i havent worked with incremental refreshes before. Thanks

[v-jiewu-msft]

Hi @ShahidYumeen ,

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.

[rajendraongole1]

Hi @ShahidYumeen  - If the "View Native Query" option is greyed out, it indicates that query folding is not occurring, which is crucial for incremental refresh

Avoid using custom columns, Merge Queries, or complex transformations early in your query. Instead, push these transformations downstream.Replace static date filters with Power Query Parameters (e.g., RangeStart and RangeEnd). These parameters are needed for incremental refresh. you can test it , by right-click any step in Applied Steps and check if "View Native Query" is enabled. If not, identify the first step where folding breaks.Incremental refresh works only with DirectQuery or Import Mode. Ensure your table is not in a mode that doesn’t support these options.

Hope the above details helps.  you can also share the exact error message you’re encountering.Provide details about your data source and transformations.