Forum Discussion

megha1's avatar
megha1
New Member
9 years ago

Handling Duplicates in PowerBI

 My excel sheet has a column with 1055 rows with all distinct values, when I am uploading the same excel sheet into powerbi, It shows only 1051 unique values found. Please suggest possible solutions as I need to build relationship using the same column which has to be unique.

Need Help

1 Reply

  • MarcelBeug's avatar
    MarcelBeug
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Export the 1051 values back to Excel and verify in Excel which of the 1055 values are missing.

    Then try and find out what is happening.

     

    A possibility can be that you values are whole numbers, except for 4 values that are decimals.

    If the column type is Int64.Type (whole number), based on the first 200 values,  then the decimal values are converted to whole numbers and this may result in duplicates in Power Query.