Forum Discussion
Solved
Generating unique keys from case-sensitive data in Power BI Desktop
Sharing with community: I ran into an issue yesterday while working with a customer evaluating Power BI. They have a MySQL source database. Their dimension table uses letters for primary keys, an...
Answer to my own question:
Power BI is case in-sensitive. Solution is to add an index column OR convert the key column data to a binary representation of value "Binary.ToText(Text.ToBinary([key column]),1))"
Binary.ToText is a power query function. It must be done as a step in the query editor. I think you're trying to do it in the table editor.
Great ! :) perfect.