Forum Discussion

robertDTS's avatar
robertDTS
New Member
7 years ago

Data Refresh Fails, Error message claims duplicate ID value in table

I have a PBIX file where when I go to refresh my data from a SQL server the refresh eventually fails with an error message that says one of my tables contains duplicate IDs. I went to my actual SQL D...
Need Help
robertDTS's avatar
robertDTS
New Member
7 years ago

No dice, which I can't say I'm suprised. We authored the application that is filling the SQL DB and while our app is not perfect, one part that is rock solid is the SWC ID. Its the unique key for that table in SQL too, so SQL will not allow duplicates (though I agree there can be situtations where something might not be seen as a dupe by SQL).

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Here's what I would do. Create a new Power BI file and copy over your query for this table. Run the import/refresh. Since it is not part of a relationship, you will not get that error and then you will be able to better assess what is causing the duplicate issue. I can't imagine you are getting that error on a lark, something is causing it.

  • robertDTS's avatar
    robertDTS
    New Member
    7 years ago

    Yeah, that is more or less where I've gotten to. Made a copy of the PBIX and started to isolate and delete stuff to see what came of it. Looks like I found a relationship causing the issue. We'll see.

     

    Thanks for replying though!

     

    -R