Duplicate value in Primary key

[Dunner2020]

Hi there,

I have created a dimension table (which I named it fact table due to some other reasons) which contains a column called EpochNumber. EpochNumber is calculated as follow:

EpochNumber = (Duration.TotalDays([Date] - #date(2010,1,1))*48) + [Half Hour Number]

The purpose of EpochNumber is to assign a unique value to the half-hour time slot that occurred on any given date. I connected to the fact table and when I click on close and apply it throws the following error:

However, when I looked on the 179759 value in the EpochHH column, there was not duplicate value. Could anyone help me in fixing the issue?

[v-robertq-msft · Accepted solution]

Hi, @Dunner2020 

According to your sample picture, I think you should keep in mind that the data displayed in the Power BI desktop is loaded in after the transformation in the Power query, so as the error said, the data can’t be loaded because it contains the duplicate value, which is not supported by many-to-one relationship.

Therefore, to find the duplicate value, you should go to the Power Query editor to check the value and transform it:

More info about what is Power Query

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tchristy99]

Hi,

If it has a duplicate value, it won't load it into the model which is why you won't be able to see it when you filter, thus giving it the appearance that there isn't a duplicate. You'll have to check your source in order to located the record that is causing you issues.