Forum Discussion
Exchange - Repeated IDs
Hi! I'm quite new on Power BI and I just found a weird problem that I'm not really sure what is causing it. We are interested in monitoring data from an specific e-mail account in order to know (...
Hi,
I have the same problem when importing mails, did you find a sollution for this?
Hi,
The problem seems to be due to minor and capital letters.
I created a new column in powerquery to convert it to Binary to have unique values.
Key = Text.Lower(Binary.ToText(Text.ToBinary([Id])))
This works perfectly. Thanks.