Is PowerBI matching case sensitive by default?

[Anonymous]

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!

[v-kelly-msft]

Hi @Anonymous ,

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]

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