Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

error: contains a duplicate value

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



1 answer

0 votes
Dirk Ronsmans Community Leader Jan 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

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you