Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
5 years ago
Solved

Duplicate value in Primary key

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 = ...
Need Help
Show and Tell
Tips and Tricks
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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's avatar
tchristy99
Helper II
5 years ago

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.