Forum Discussion

mjfulke's avatar
mjfulke
Microsoft Employee
10 years ago
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...
  • mjfulke's avatar
    mjfulke
    10 years ago

     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))"

     

     

mjfulke's avatar
mjfulke
Microsoft Employee
9 years ago

Try "Binary.ToText(Text.ToBinary([_id]),1))"

fritz's avatar
fritz
Advocate I
9 years ago

I have the same Issue, no blanks, no nulls, all values unique.

It also seems connected to the size of the table (~80000 rows).