cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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.

1 REPLY 1
Highlighted
Community Champion
Community Champion

Re: Handling Duplicates in PowerBI

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.

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors