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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
UsePowerBI
Post Prodigy
Post Prodigy

Is PowerBI matching case sensitive by default?

Hello

 

I have merged two tables (A and B) using common column. I bring ColA1 from A table into a table visual and then I bring ColB1 from B table.

 

Both columns supposedly have the same values so I see the matches between the two tables. However, one particular match is missing and I wonder if this is because of case sensitivity.

 

Any idea? Do you know how to make it non-case sensitive?

 

Thanks!

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi @UsePowerBI ,

 

What kind of match is missing?Could you pls provide some screenshots to make the issue more clear?

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
amitchandak
Super User
Super User

@UsePowerBI , is it about data or column name? Column name/meta is case sensitive in Power Query/M not in Dax.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.