Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

How to make a Merged Query non case sensitive?

Hello

 

I joined two tables with Merged Query using Left Outer join.

 

It appears it only matches case-sensitive data and it omits all the non case-sensitive matches.

 

How can I fix this?

 

Thanks

5 REPLIES 5
Xcellent101
New Member

You can try to do a fuzzy match when you are doing the Merged Query

https://support.microsoft.com/en-us/office/create-a-fuzzy-match-power-query-ffdd5082-c0c8-4c8e-a794-...

 

Make sure to set

Similarity Threshold = 1.0 (so you get exact matches)

Ignore Case = Check

 

As always, make sure to test the matched results before pushing to prod.

 

 

Similarity Threshold     Indicates how similar two values need to be in order to match. The minimum value of 0.00 causes all values to match each other. The maximum value of 1.00 only allows exact matches. The default value is 0.80.

Ignore case     Indicates whether text values should be compared in a case sensitive or insensitive manner. The default behavior is case insensitive, which means case is ignored.

amitchandak
Super User
Super User

@Anonymous , Using text-upper, create a new column in both tables and join in Power Query

 

https://docs.microsoft.com/en-us/powerquery-m/text-upper

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

@amitchandak @az38 

 

Thanks but I wouldn't like to change the case of the data, is it possible that I introduce a parameter in the Power Query code so that it is non case-sensitive?

az38
Community Champion
Community Champion

@Anonymous 

you can try to use solution with "keyEqualityComparers" parameter from here https://community.powerbi.com/t5/Desktop/PowerQuery-Merge-Queries/td-p/149565

But it's not recommended and it's always (from my experience) a bad practice to join by text (especially long case-senisitve text)


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
az38
Community Champion
Community Champion

@Anonymous 

you can execute lowercase or UPPERCASE operation before left join


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors