Forum Discussion
Incremental refresh in Dataflows using Business Central
Dear v-venuppu ,
tried your approach, but even in the first step it doesn't give me the native query option.I also contacted Microsoft, this is the answer I got:
"Unfortunately, our OData stack (on which APIs are built on) in Business Central does not support this."đ
Hi Powerwoman ,
This happens when query folding is broken.
If your connector (e.g., Dynamics365BusinessCentral.ApiContentsWithOptions) doesnât support folding beyond certain steps, filters are applied after fetching all data, which defeats the purpose of incremental refresh.
Here is an recommended approach to solve the issue:
1.Use OData.Feed() connector instead of ApiContentsWithOptions.
This allows query folding to the Business Central source.
Folding is necessary for RangeStart and RangeEnd filters to be effective.
2.Apply date filters directly using RangeStart and RangeEnd:
3.Avoid transformations before the filter step that could break query folding.
How to confirm whether it works or not:
Right-click the filtering step in Power Query and check if âView Native Queryâ is enabled.
If itâs greyed out, folding is broken and incremental refresh wonât behave correctly.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly.
Thank you.
Dear v-venuppu ,
tried your approach, but even in the first step it doesn't give me the native query option.
I also contacted Microsoft, this is the answer I got:
"Unfortunately, our OData stack (on which APIs are built on) in Business Central does not support this."
đ