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, a094L000008l6...
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)
Greg_Deckler I can see the link to the video. Please share thanks
Greg_Deckler
Community Champion
Community ChampionAnonymous 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)