Toggle button to enable incremental refresh in faded

[Anonymous]

Hi team,

Hi have data which called from MangoDB through API

I just wanted to enable incremental refresh from oct-23 to nov-23
I set the parameter "RangeStart" Current Value (01-10-2023) and "RangeEnd" Current Value (30-11-2023)
applied the filter as well in power Query but while enbling the incremental refresh in PBI desktop the toggle button is not available to click
my screen is showing as below and i marked the perticular part

Someone please help me out to get sollution
Thanks

Rajesh G

[Uzi2019 · Accepted solution]

Hi @Anonymous 
Nope. It means you can not apply incremental refresh on your data source. this issue occurs because of query folding. 

Please refer this link for better understand.
https://www.biconnector.com/blog/query-folding-power-bi-everything-you-need-to-know/#:~:text=Query%20Folding%20is%20the%20capability,vast%20volume%20of%20data%20efficiently.

I hope I answered your question please give kudos and accept it as a solution.

Thanks

[Uzi2019]

Hi @Anonymous 
This might be an issue of a query folding. 
In the Power Query Editor window, it's possible to determine when a Power Query query can be folded. In the Query Settings pane, when you right-click the last applied step, if the View Native Query option is enabled (not greyed out), then the entire query can be folded.

If this is Grey out it means incremantal refresh is not supported in your datasource.

If my post helps please give kudos and accept it as a solution!
Thanks

[Anonymous]

yes @Uzi2019 
As you said it is View Native Query optin in grayed out.
Is it possible to enable it?

[Uzi2019 · Accepted solution]

Hi @Anonymous 
Nope. It means you can not apply incremental refresh on your data source. this issue occurs because of query folding. 

Please refer this link for better understand.
https://www.biconnector.com/blog/query-folding-power-bi-everything-you-need-to-know/#:~:text=Query%20Folding%20is%20the%20capability,vast%20volume%20of%20data%20efficiently.

I hope I answered your question please give kudos and accept it as a solution.

Thanks

[Anonymous · Accepted solution]

Thanks @Uzi2019 for made me understand

Rajesh G

[Idrissshatila]

@Anonymous , are you sure you named the range start and range end as they should be named, because if you didn't name them as the screenshot it won't work.

sldo you can check this https://youtu.be/Kui_1G6kQIQ?si=ZoqP76OroiS8oNay

[Anonymous]

Yes @Idrissshatila 
I named as the screenshot
please find below screenshot of mine

Can you please give me a solution?