Forum Discussion
How to handle Case Sensitive on a primary key
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.
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)
3 Replies
- Greg_Deckler
Community Champion
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:
Greg_Deckler I can see the link to the video. Please share thanks
- Greg_Deckler
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)