Updated on

JoinAlgorithm.Dynamic (0) is an enumeration that specifies the join algorithm to be used in the join operation. It is a member of the JoinAlgorithm.Type and indicates that the join algorithm is automatically chosen based on inspecting the initial rows and metadata of both tables.


The Dynamic join algorithm is useful when you want to let Power Query decide which algorithm to use. It automatically chooses the best algorithm based on a scan of the rows and metadata of the tables involved in the join. How it works under the hood is (currently) undocumented.

= Table.Join(
     JoinAlgorithm.Dynamic // join algorithm chosen automatically

Other related enumerations are:

Applies to

Here’s a list of functions that work with JoinAlgorithm.Type:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot