Forum Discussion

shaunwilks's avatar
shaunwilks
Helper V
5 years ago
Solved

Incremental Refresh - Query Folding - How to Tell - PowerQuery vs PBI Desktop

Did a deep dive into Query Folding for the purpose of Incremental Refresh.  Read through here in addition to other resources https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding h...
General Comment
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  shaunwilks ,

     

    After checking,if View Native Query option is enabled,it means that it is highly likely to have query folding,but it's not definite.When you do some transformations that SQL can't parse,you will get such notification to advise you that the query might not be folding back,but this is also not definite,you'd better use other tools such as SQL profiler or Azure data studio,etc to check whether the query folding is taken place.

     

    In below vedio,Patrick tells how to check whether query folding is happening:

    https://www.youtube.com/watch?v=QEFze-LdLqo

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

  • shaunwilks's avatar
    shaunwilks
    Helper V
    5 years ago

    I have read that... It also says

     

    "Checking the View Native Query option is always recommended to make sure that your query can be folded back to the data source. If your step disables this option, you know that you've created a step that stops query folding."

     

    I have a data source where View Native Query works = Folding is working..

    I dont have a problem getting the query to fold.

     

    But then back in the editor setting up incremental updates on the VERY same query tells me

    "Unable to Confirm if the PBI Query can be folded." 

     

    So the query editor tells me its folding. But the Editor is warning it cannot be confirmed.

    Why cant both applications be consistent ?? 

     

    What tests does the incremental refresh perform to show that warning, that the Query Editor does not ?

     

    Clearly they are different checks and only causes confusion for thos trying to configure incremental refresh. 

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi  shaunwilks ,

       

      After checking,if View Native Query option is enabled,it means that it is highly likely to have query folding,but it's not definite.When you do some transformations that SQL can't parse,you will get such notification to advise you that the query might not be folding back,but this is also not definite,you'd better use other tools such as SQL profiler or Azure data studio,etc to check whether the query folding is taken place.

       

      In below vedio,Patrick tells how to check whether query folding is happening:

      https://www.youtube.com/watch?v=QEFze-LdLqo

       

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!