Apply query changes

[Anonymous]

I have connected PowerBI to a table on SQL server  through Import Mode Method. If i do any edits in query editor and then click on close & apply or apply, everytime it download the data again from server thus leading to lot of delay in completing the query changes. 

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

Have you apply any advanced operation in query editor?(e.g merge, append, reference other steps, invoke custom functions...) 

If that is a case, they will cause the looping calculation and duplicate cost on memory resource, you can consider to use Buffer functions to package these steps.

How and When to use List & Table Buffer?

Regards,

Xiaoxin Sheng