Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    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!