Forum Discussion
Why power query consumes all my resources?
If you use modular approach that could help. Use separate query/queries to load data, another query to merge (one for each merging), another to combine, etc. Grouping could be critical for the performance, check if it could be optimized. Remove unnecessary columns on early stages.
SQL connector in general faster and perhaps query folding works in this case, that means transformations are done on the server.
If you use modular approach that could help. Use separate query/queries to load data, another query to merge (one for each merging), another to combine, etc. Grouping could be critical for the performance, check if it could be optimized. Remove unnecessary columns on early stages.
SQL connector in general faster and perhaps query folding works in this case, that means transformations are done on the server.