error: contains a duplicate value

Fabio Farè January 11, 2022

Good evening,
we in our system have plugins that make our pwerBI work to make queries.
In a report we get a very strange "contains a duplicate value" error. (followed the screen)
errore jira.PNG

 

What could be the problem?
can you help me?

We run the query while waiting for the report to be ready and we get this error.
I am available if you have any questions to better understand the cause of the problem and to find a solution.
Thank you
Regards

 

 

1 answer

0 votes
Dirk Ronsmans
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 11, 2022

Hi @Fabio Farè and welcome to the community!

I'll have to do a bit of guess work here but

As you are getting the error when you run the report this most likely (can't be certain without the report in front of me) it is due to a primary key that was set on your data model.

Seems to be a date field that it's "failing" on.

I'm afraid you won't be able to do much on this one on the Jira side but it'll have to be fixed on the PowerBI side by eliminating the primary key on that date field.

Suggest an answer

Log in or Sign up to answer