Forum Discussion
Retain case sensitivity when passing values from Power Query to Power BI
You could group by the INSTR_ID field, add an index column, merge withe original table by INSTR_ID, then merge the INSTR_ID with the index column. That way the Index suffix will act as the "differentiator"
or, follow the steps outlined in this blog entry:
https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/amp/
You could group by the INSTR_ID field, add an index column, merge withe original table by INSTR_ID, then merge the INSTR_ID with the index column. That way the Index suffix will act as the "differentiator"
or, follow the steps outlined in this blog entry:
https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/amp/
Thanks PaulDBrown for your suggestion. I have already tried this and it worked, but I was then trying to remove the index from the merged value within the Desktop using DAX in order to get back to a clean INSTR_ID value - but when doing this it lost the case sensativity.
If there is no way to get back to a clean (& accurate) INSTR_ID in PBI Desktop, then I'll stick with the merged version.I added a link to a blog entry in my original reply which enables retaining case sensitivity
