The fuzzy merge documentation doesn't match observed functionality. The following page (https://support.microsoft.com/en-us/office/create-a-fuzzy-match-power-query-ffdd5082-c0c8-4c8e-a794-bd3962b9064...
lasersharks
Kudo Collector
Kudo CollectorAre you saying that threshold controls the number of matches (one-to-many in your words). This is not what the docs say at all. The number of matches is controlled by the " Maximum number of matches " setting. Please can you provide further clarity or ask someone in the PQ team to take a look.