Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post 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 

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi PowerBI123456 ,

 

If the error is still there then there is duplicate value in key column for sure.

Can you share your data model? Or if possible the pbix file by removing any sensitive information.

 

Thanks,

Pragati

  • PowerBI123456's avatar
    PowerBI123456
    Post Partisan
    5 years ago

    Pragati11 Unfortunately I can't share, its all PHI. 

    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      Hi PowerBI123456 ,

       

      But there has to be some blanks or duplicate values. As parry2k suggested, can you check if you have any filters on your report which is not showing you this data?

       

      Thanks,

      Pragati