Forum Discussion

PowerBI123456's avatar
PowerBI123456
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Duplicate Values

I am getting an error in Power BI service saying I have a duplicate value in one of my keys that is a 1 to many relationship. In power query, I removed all duplicates and nulls. I even looked up the ...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    5 years ago

    PowerBI123456 Reason I brought that up, in case you have partial data in desktop and during incremental refresh, you have full data load and that's when there is a duplicate /blank value and causing the issue in the service and not in the desktop since in desktop you are seeing partial data.

     

    If you are using incremental refresh, you check at your backend (not sure what is your data source) and see if you are getting any duplicate values, maybe run the query against the full dataset. As we know there can be many reasons for it, you have to look at the full dataset to identify the problem.

     

    I would also recommend taking the actions recommended by smpa01 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

PowerBI123456 hmmm, are you doing incremental refresh, or something changing in service, like data source or in the desktop you are loading partial data compare to what gets loaded in Power BI service.

 

Have you done a full refresh on the Power BI desktop to test it?

 

  • PowerBI123456's avatar
    PowerBI123456
    Icon for Post Partisan rankPost Partisan
    5 years ago

    parry2k Doing incremental refresh in service. Is that what is causing it?