Forum Discussion
Apply query changes
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 se...
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
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