How to handle Case Sensitive on a primary key

[Anonymous]

I have an issue with Power BI handling Primary Key with case sensitive.
For example, I have a SQL table and it primary key is case sensitive on ID eg. a094L000008l69G, a094L000008l69g, a094L000008l69k, a094L000008l69K and they are different. When i import in Power Query, it shows the above values as unqiue but the moment I click on Apply & Load, they are not unqiue any more. It return a094L000008l69G and a094L000008l69K as two values instead of four values.
screenshot shows how it look like in power query 

and when Apply & Load is clicked the power bi desktop shows

How can i fix this? The supplierID are unique.

[Greg_Deckler]

@Anonymous Yeah, this is a huge problem with Power BI basically munging your data on import. This video demonstrates one technique to deal with the problem:

[Anonymous]

@Greg_Deckler I can see the link to the video. Please share thanks

[Greg_Deckler · Accepted solution]

@Anonymous The short answer is that you need to do a find and replace of all upper case characters with the upper case character plus a unicode 8203 character. Chris Webb's article on this also is a good read. Chris Webb's BI Blog: Power BI And Case Sensitivity (crossjoin.co.uk)