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 server thus leading to lot of delay in completing the query changes.
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
1 Reply
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