Dataflow refresh : "An entry with the same key already exists"

Question

Hi, I have a dataflow that references a linked entity and performs some minor transformations.&nbsp;I am sporadically getting refresh issues with it.&nbsp; The error is :&nbsp;Error: An entry with the same key already exists... RootActivityId = xxxxxxxxxxxxxxxxxxxxxxx .Param1 = An entry with the same key already exists. Request ID: xxxxxxxxxxxxxxxxxxxxxxx&nbsp;What makes it hard to troubleshoot is, usually next refresh it works fine...or if i go and refresh manually.&nbsp;(I have raised a ticket with Microsoft a week or so back so they are looking into it.)&nbsp;Would some kind of resource threshold being hit in the service cause these sporadic errors ?&nbsp; There are some other datflows set to refresh at the same time.

anonymous · Answer

Hi &nbsp;frano72,&nbsp;I cant reproduce your senario and after searching many documents,I failed to solve your issue,so pls create&nbsp; a support ticket via below link and our relevant personnel will help to handle it.https://powerbi.microsoft.com/en-us/support/&nbsp;&nbsp;&nbsp;Best Regards,KellyDid I answer your question? Mark my post as a solution!

frano72 · Answer

Thanks&nbsp;Anonymous&nbsp; - I already have a ticket ongoing, i just posted it online in case someone in the community had any ideas.&nbsp; I'll post back here if Msft come up with anything.

tbowman · Answer

frano72&nbsp;This is happening quite a bit on several dataflows in another tenant as well. Has MSFT gotten back to you on the issue/solution?

frano72 · Answer

tbowman&nbsp;- yeah product engineering were working on a fix and it was due to be fixed by Aug 13, but i am still getting the error.&nbsp;Have followed them up this week, but haven't heard back...

samurize24 · Answer

Hi,Same issue, with schudele refresh the same error is produced, but when i manuely refresh is works fine.Any update how to workaround this would be helpfull.&nbsp;&nbsp;

Forum Discussion

Related content

How to Remove "( )" from an existing colunm

Does Dataflow Gen2 Require an "Enhanced" Fabric Capacity License?

Power BI "An Active relationship already exists between tables" Deactivate the existing relationship

Fabric Dataflow Gen 2

dataflow gen1