Forum Discussion
PowerBi Dataflow duplicate some row when imported in a report
Hello, I have come across something that I haven't managed to understand while working with dataflows. In one of my tables (after importing the dataflow in a powerbi report), some rows where duplica...
v-yanjiang-msft
Community Support
Community SupportHi Anonymous ,
Please try the workaroud in this thread:
Make sure your target table has a Key set up that uniquely identifies each row (maybe just the name? or a composite of name and type?) Dataflow will pick up on the key on the table and for all the rows to be imported it will use the key to upsert instead of just inserting.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
I've tried adding a key using the Table.AddKey function (and while specifying that it is a primary key) on my single-row table, but I still get a duplicate when I import it.
Best Regards,
Valentin