error: contains a duplicate value

Fabio Farè_tfkesg

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)

 

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

 

 

Dirk Ronsmans

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.