Forum Discussion
Issue with Query Folding for Incremental refresh
Hi rasika_pawar,
To resolve the issue you encountered in Power BI, the best approach is:
1) Keep all foldable transformations (like parameter filters, column removal) in a separate base query.
2) Rename this base query (e.g., SalesData_Staging).
3) Right-click on the base query → choose "Reference" to create a new query (e.g., SalesData_Final).
4) Apply all non-foldable steps (e.g., custom columns, merges, groupings) only in the referenced query.
5) This prevents re-filtering and keeps parameter-based filters intact.
6) Disable loading of the base query (right-click → uncheck "Enable Load") to reduce memory usage.
7) Load only the final query (SalesData_Final) into the data model In the base query, use "View Native Query" after each step to verify that query folding is still activeRegards,
Chaithanya.
Hi rasika_pawar,
To resolve the issue you encountered in Power BI, the best approach is:
1) Keep all foldable transformations (like parameter filters, column removal) in a separate base query.
2) Rename this base query (e.g., SalesData_Staging).
3) Right-click on the base query → choose "Reference" to create a new query (e.g., SalesData_Final).
4) Apply all non-foldable steps (e.g., custom columns, merges, groupings) only in the referenced query.
5) This prevents re-filtering and keeps parameter-based filters intact.
6) Disable loading of the base query (right-click → uncheck "Enable Load") to reduce memory usage.
7) Load only the final query (SalesData_Final) into the data model In the base query, use "View Native Query" after each step to verify that query folding is still active
Regards,
Chaithanya.