Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
yes @Uzi2019
As you said it is View Native Query optin in grayed out.
Is it possible to enable it?
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 , 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
Proud to be a Super User! | |
Yes @Idrissshatila
I named as the screenshot
please find below screenshot of mine
Can you please give me a solution?
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
84 | |
65 | |
63 |