There should be an option in Power BI for the data in the columns to be either case sensitive or insensitive. When one deals with data involving client names or entity names, case sensitivity-sinsens...
To set a case-sensitive collation on the semantic model, configure the Collation option with a case-sensitive collation value when creating the model. This setting applies to the entire model and cannot be configured at a more granular level. For example, you can set the collation to
SQL_Latin1_General_CP1_CS_AS, which is a case-sensitive collation.
