Forum Discussion

BishwaR's avatar
BishwaR
Helper V
5 years ago

Query fold and incremental refresh

I have used the SQL query in the Advance Option to import the table into the model.

When I tried to set the incremental refhresh it failded because it could not do the query folding.

 

Is there any workaround to this problem ?

 

Thanks

 

Bishwa

Need Help

3 Replies

    • BishwaR's avatar
      BishwaR
      Helper V
      5 years ago

      My SQL is 2 pages long and lots of subqueries . Is there any templete to ease my transfermation ?

      Or I have to manually change every code in M ?

       

      Thanks

      Bishwa

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi BishwaR ,

     

    If you used the SQL query in the Advance Option, query folding will not work.

    You need to use the M language to make changes in Power Query or make changes in the data source.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.