Forum Discussion
How to handle Case Sensitive on a primary key
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)
Community ChampionAnonymous 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)