Handling Duplicates in PowerBI

[megha1]

 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.

[MarcelBeug]

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.