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...
The lack of case sensitivity and cases changing on load from Power Query to Power BI entirely prevents me from using Power BI in many cases. I'll be moving away from Power BI as a reporting solution solely because of this issue.
