Forum Discussion
Performance of Excel vs Database Data Source
HI Anonymous,
AFAIK, If you only get data from excel and merge them, it should works well without any performance issues.Have you do any advanced operation on these query?(e.g. invoke custom function, refer any query table in calculate, refer previous query steps)
These operations may cause the memory issue.(power query will spend memory resource multiple times to handle each row calculation)
If that is a case you can consider to use list.buffer or table.buffer to cache reference source to memory to reduce cost of resource.
How and When to use List & Table Buffer?
Regards,
Xiaoxin Sheng
HI Anonymous,
AFAIK, If you only get data from excel and merge them, it should works well without any performance issues.
Have you do any advanced operation on these query?(e.g. invoke custom function, refer any query table in calculate, refer previous query steps)
These operations may cause the memory issue.(power query will spend memory resource multiple times to handle each row calculation)
If that is a case you can consider to use list.buffer or table.buffer to cache reference source to memory to reduce cost of resource.
How and When to use List & Table Buffer?
Regards,
Xiaoxin Sheng
Right, I have operations which refers to previous query steps.
Thanks Anonymous! I'll check out table.buffer.