Power BI text case changing automatically

Question

So, my Power BI is connected to a SQL Server where I am reading a text field that is case sensitive in my sql server, but when the data arrives in power BI, it's all in the same case.

For example, in my database, I have the elements - "mixed", "Mixed" & "MIXED", when I read data from power BI all data is "mixed".

Can anyone tell me what's going on? Any help is much appreciated.

Answer 1

Power BI doesn't handle case sensitivity that well after the query stage, at the moment. A current workaround is to create a dimension table with an index and work with that index instead.