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...
Hello, As a new Power BI user, I was quite surprised to discover that string comparisons are not case-sensitive by default in many scenarios. From a data management and analytics perspective, this can be a significant limitation, as there are legitimate use cases where "a" and "A" represent different values and should be treated accordingly. While I understand that case-insensitive behavior may be convenient for some users, it should at least be configurable. Modern professional data platforms typically provide an option to choose between case-sensitive and case-insensitive comparisons, allowing the behavior to align with business requirements and source system semantics. The current approach can lead to unexpected results, especially when working with identifiers, codes, or datasets originating from systems where case sensitivity is meaningful. I believe Power BI would benefit from offering a global or model-level setting that allows developers to define how text comparisons and relationships should handle case sensitivity. Thank you for considering this enhancement. It is difficult to understand why such a fundamental capability is not available as a configurable option in a modern enterprise-grade analytics platform.
