Forum Discussion

aleggore's avatar
aleggore
Frequent Visitor
4 years ago
Solved

Duplicate values

I am finding duplicate values in my dataset after I try to refresh. There are no duplicate values showing when I run my query independently or in Power Query before I load to PowerBI. Has anyone seen...
Need Help
  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    4 years ago

    power query doesnt load all the data since its just load a sample data for you to see the tranformation you doing, when you apply the query power bi desktop does pull all the data from the source, so probably there its some duplicate on the source data, or a tranformation you applying its generating the duplicate (this can be the case happends frenquently over merge or append steps)

StefanoGrimaldi's avatar
StefanoGrimaldi
Resident Rockstar
4 years ago

power query doesnt load all the data since its just load a sample data for you to see the tranformation you doing, when you apply the query power bi desktop does pull all the data from the source, so probably there its some duplicate on the source data, or a tranformation you applying its generating the duplicate (this can be the case happends frenquently over merge or append steps)