Incremental Refresh and Query Folding

Hi Anonymous  - 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.