How to keep case sensitive information for each ID?

[GM30]

I have a dataset of around 20,000 rows, and I would like to keep individual columns' exact values for each unique ID including their capitalization. However, PowerBI will refer to the first instance of the data and use that capitalization format for the rest of the table.

This is an example of my data (which is how I want the data to be):

ID	First_Name	Last_Name
1	STEVE	SMITH
2	John	Smith
3	SteVE	Smith
4	Mark	Thomas

This is how PowerBI default outputs:

ID	First_Name	Last_Name
1	STEVE	SMITH
2	John	SMITH
3	STEVE	SMITH
4	Mark	Thomas

In the query editor, the information is correct. In model view, or in the report, it is as above.

Basically, I would like a way to keep case sensitive information for each row/ID. Any suggestions?

[GM30 · Accepted solution]

found a solution:

https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/