Forum Discussion
Dataflow Gen2 Incremental Refresh Error with Business Central
Hi,
Can Anyone Help me to Implement Power BI Incremental Refresh in Dataflow.
Datasource is from D365 Business Central Online.
on top of it i did some Transformation and Append Tables as well.
But after Setup Incremental Refresh i was Getting Error Related to "Failed to verify that a query with incremental refresh is folding".
Tables:
Connection
No Query Folding Option.
Hi ShahrukhHB,
We appreciate your inquiry on the Microsoft Fabric Community Forum.The error "Failed to verify that a query with incremental refresh is folding" indicates that query folding is not occurring. Since incremental refresh relies on query folding, all transformations applied in Power Query must be translatable to the data source.
Kindly follow the steps mentioned below, which may help in resolving the issue:
- Review transformations and ensure that query folding is supported. Avoid transformations that can break it, such as merging or appending queries, adding custom columns, grouping data, and changing data types. Minimise these before applying incremental refresh.
- Load only the necessary columns from the Business Central source. Where possible, use SQL queries to fetch data, ensuring that filters are pushed to the source. If multiple transformation steps exist, consider consolidating them. Apply filters early to reduce data volume before performing complex transformations.
- Apply the incremental refresh policy to a Date/Datetime column in the query. Ensure that parameters like RangeStart and RangeEnd are correctly configured in Power Query.
- Right-click the last step of the query in Power Query and select "View Native Query." If this option is disabled, query folding is not occurring, and the transformations need to be reviewed and adjusted.
- Save the modifications and refresh the dataflow. Monitor the process for any new errors.
Additionally, please find below some reference links for further guidance:
Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
Troubleshoot incremental refresh and real-time data - Power BI | Microsoft LearnIf you find this response helpful, kindly mark it as the accepted solution and provide kudos, as it will assist other community members facing similar queries.
Thank you.
5 Replies
What do you like to get help with?
Hi ShahrukhHB,
We appreciate your inquiry on the Microsoft Fabric Community Forum.The error "Failed to verify that a query with incremental refresh is folding" indicates that query folding is not occurring. Since incremental refresh relies on query folding, all transformations applied in Power Query must be translatable to the data source.
Kindly follow the steps mentioned below, which may help in resolving the issue:
- Review transformations and ensure that query folding is supported. Avoid transformations that can break it, such as merging or appending queries, adding custom columns, grouping data, and changing data types. Minimise these before applying incremental refresh.
- Load only the necessary columns from the Business Central source. Where possible, use SQL queries to fetch data, ensuring that filters are pushed to the source. If multiple transformation steps exist, consider consolidating them. Apply filters early to reduce data volume before performing complex transformations.
- Apply the incremental refresh policy to a Date/Datetime column in the query. Ensure that parameters like RangeStart and RangeEnd are correctly configured in Power Query.
- Right-click the last step of the query in Power Query and select "View Native Query." If this option is disabled, query folding is not occurring, and the transformations need to be reviewed and adjusted.
- Save the modifications and refresh the dataflow. Monitor the process for any new errors.
Additionally, please find below some reference links for further guidance:
Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
Troubleshoot incremental refresh and real-time data - Power BI | Microsoft LearnIf you find this response helpful, kindly mark it as the accepted solution and provide kudos, as it will assist other community members facing similar queries.
Thank you.
Hi ShahrukhHB,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.
Hi ShahrukhHB,
We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.
If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.
Thank you.Hi ShahrukhHB,
We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.
Thank you.
