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...
This is a huge problem for the architecture/engineering/construction community (BIM/VDC). We want to use the unique IDs of the IFC file format (IFC GUID) for 3D buildings and their data, but it's a case sensitive key. Example: 2F$L$p5YXH0f$q71wYJpYv As a result, what should be a simple logical connection becomes a data nightmare and many people from the BIM world who look at PowerBI immeditely consider it innapropriate as a solution for the data handling of BIM/VDC documents. - Also consider that many people who are not eagle-eyed will not notice the defficiency of the data, as Marco and Alberto said: "Users are not expected to even realize that incorrect results might be linked to case-sensitivity" https://www.sqlbi.com/articles/letter-case-sensitivity-in-dax-power-bi-and-analysis-services/
