How to make Powerquery run faster

ClarkChao 

Few ways which could help and no one which definitely helps. Everything depends on concrete situation.

You may check Chris Webb series with recommendations on performance optimization, first I found Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge Chris Webb's BI Blog (crossjoin.co.uk)