Optimising The Performance Of Power Query Merges In Power BI, Part 4: Table.Join And Other Join Algorithms

(Chris Webb) In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better performance for merge operations in Power Query – but only if your data is sorted.