Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

Folding Table.Join By Using Table.View - keyEqualityComparers



Table.Join takes an optional keyEqualityComparers argument. According to the docs, this "is currently intended for internal use only."


When handling OnJoin from a Table.View, the join key details passed into the handler include equality comparers. Will there be cases where Microsoft's internal use of Table.Join's keyEqualityComparers argument leads to my OnJoin being passed a non-default comparer, or can I expect that OnJoin will be always and only passed the default comparer (that is, Comparer.Ordinal)?


Thank you!

Community Support
Community Support

Hi @Ben-Dev ,


There is no official documentation with information about 'keyEqualityComparers', perhaps you can refer to the following thread: joinAlgorithm and keyEqualityComparers 


Best Regards,


Hi @v-kkf-msft


Thanks! Any way we can get some insight from the custom connector dev team here?  If I'm implementing a Table.View, my OnJoin handler is passed equality comparer(s). Since Power Query is passing them to my handler, it seems like I need to know what to do with them. 🙂



Am I supposed to do something with them, or is the official Microsoft position that I should ignore them?



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors