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 

parry2k's avatar
parry2k
Super User
5 years ago

PowerBI123456 that is weird, has to be blank or empty. I hope you don't have a filter on the page that is filtering the rows you are seeing in table visual.

  • PowerBI123456's avatar
    PowerBI123456
    Post Partisan
    5 years ago

    parry2k No page filters. Its weird because it loads in Desktop with no issues, but runs into an issue in service only.