Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
Arioli_Chezhian
Helper II
Helper II

Query folding for incremental refresh

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.

Arioli_Chezhian_1-1690265795610.png

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. 

Arioli_Chezhian_2-1690265934521.png

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.

4 REPLIES 4
Idrissshatila
Super User
Super User

@Arioli_Chezhian ,

 

yes proceed.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




@Idrissshatila 
Great! Thanks!!!

Idrissshatila
Super User
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 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

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?

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.