Power BI-Incremental Refresh Issue

Hi Perfecta I think it is because the M code uses non-foldable transformations, breaking query folding required for incremental refresh. Modify the code to pass RangeStart and RangeEnd directly to the API and remove unnecessary filtering like Table.SelectRows. Ensure foldable transformations by checking the query folding icon in Power Query.

Hi Perfecta ,

Thanks for reaching out to the Microsoft fabric community forum.

Akash_Varuna 

Thanks for your prompt response

In addition to Akash_Varuna , I have added learning documents and previously solved threads here. They may help you resolve the issue.

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

Solved: query folding error while doing incremental refres... - Microsoft Fabric Community

Solved: Incremental refresh with appended queries - Microsoft Fabric Community

Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn

Solved: Query Folding - Microsoft Fabric Community

Solved: Using web source for incremental refresh - Microsoft Fabric Community

Solved: Incremental Refresh of data coming from Rest API o... - Microsoft Fabric Community

Thanks for reaching out to the Microsoft fabric community forum.

If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana