Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Changing the ID letter case after loading into model

Hi, I encountered a strange case, probably bug, with an ID column. The ID's in my database are unique for each record, but only including case-sensitivity (which I know that Power Query applies). S...
Need Help
MartynRamsden's avatar
MartynRamsden
Icon for Solution Sage rankSolution Sage
6 years ago

Hi Anonymous 

 

Chris Webb wrote a great blog post about Power BI case sensitivity in October 2019.

You can find it here: blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/ 

 

There's a section near the end where he explains how to add a zero-width spaces in Power Query to force case sensitivity in the Power BI engine.

Hopefully this will help in your situation.

 

Best regards,

Martyn

 

If I answered your question, please help others by accepting it as a solution.