So I did search for this and didn't find any help. Just to start of, I understand what this error message means and why it is in place. However, I think it is erroneous. Since my data starts in Excel files I started examinging the column there. I used conditional formating to highlight what Excel thinks are duplicates and they are not. The first 15 digits are the same but not the last 4. I did find that Excel has a limitation at 15 digits so I change the colum type to text and it still highlights them as duplicate. I also edited my query in Power BI to make the text and no relief from the problem. This is a set of values that Excel things are duplicate. I have sorted this column so duplicates would appear next to each other.
Any insights on how I can get Power BI to recognize these values as unique?
@BruceRudd do you have any blank/empty value in your dataset. If it is then you will not able to set relationship on this column.
In the Query Editor, select your dataset (top left corner of the data table), and add a final step (Remove Duplicates) to the dataset.
Good question. These are supprt case number so their shouldn't be any blanks but that does not mean their aren't. I'll check it out.
Thanks for the reply but since it appears that these are erroneous errors, I don't want to delete the false positive duplicates.
Is the data in Excel file unique. If it is not, then it needs to be fixed in Excel first. I tried to copy paste the numbers you provided into an excel file and had to use text import wizard to paste the numbers as text. And only then I could get the unique numbers.
Could you share the excel file that you are using as a data source for Power BI.
Yes, they are unique. I had tried change the data type of the column to text thinking that would help but it didn't seem to affect anything. Maybe the cut and paste is needed to convert it. Unfortunatly, I can't share the full file as it very large and propiretary.