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...
When querying from SQL, or other source that are not case insensitive, forcing case sensitivity isn't efficient. It increases risk of developer making mistakes. They test in SQL, the query works perfectly. Copy in PowerBI, then spend time fixing case-sensitivity. There is no added value.
Rather, it should be a property. For people that need case-sensitivity, they can have it. People that don't can turn it off.
Power-BI needs to be flexible and to adapt to the multiple sources.
