Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi All,
I am using Oracle as data source. I want to set up incremental refresh for my dataset.
I have only 2 steps in Power query - applied steps.
First is getting the source and the second step is applying the RangeStart and RangeEnd parameter as filter. However "View native query" is greyed out for that step.
I believe only if query folding is enabled, then only we can set up the incremental refresh. In this case how should we enable the "view native query"?
Please advice how to set up the incremental refresh with respect to this issue.
yes proceed.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @Arioli_Chezhian ,
the native query is not directly related to query folding and it could work normally without it.
check it out https://youtu.be/Kui_1G6kQIQ
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Thanks for your response @Idrissshatila
So I can proceed further to set up incremental refresh right?
Since the "view native query" is greyed out, it won't impact the incremental refresh process. Is it correct?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.