Query fold and incremental refresh

[BishwaR]

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

[Anonymous]

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.

[Greg_Deckler]

@BishwaR Yes, do the same transformations in M that you do in your SQL query.

[BishwaR]

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