Error when refreshing in PB

Cristinafox · ‎11-17-2021

Hello,

I have a report in Power bi, that I use to refresh month by month. Now, after trying to refresh and without doing any changes to my source, I got this message:"a specific column contais a duplicate value and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table".

Now, I am a beginner on Power bi, but to avoid receiving this errorr, I went to the column named in the error and I have removed duplicates, after that, my refresh worked. Do you think is it ok or should I go for another solution? And which one?

Thanks!

KNP · ‎11-17-2021

Hi @Cristinafox,

Can you show an image of the table relationships from the modelling tab?

Removing the duplicate is only applicable if that table shouldn't have duplicates.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.