Cleaning a dimension table correctly

[akhaliq7]

What is the steps required to clean a dimension table that is sourced from a relational database. The dimension table I am referring to contains more rows than my fact table. Can someone provide me with a set of steps they take if any. 

[amitchandak]

@akhaliq7 , Remove duplicates. Add Index columns

Watch Video 2,3,4 in this series

https://www.youtube.com/playlist?list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

[akhaliq7]

it already has the duplicates removed and it already has a primary key, Just has too many rows that are not in the fact table

[PaulDBrown]

You might need to run the Trim and Clean transformations (under Transform -> Format in the ribbon) before removing the duplicates to make sure there aren't any rogue spaces which will not be picked up when removing duplicates. Aslo beware of how the values are spelt: capitals and lower case are treated as different values in Power Query

After removing duplicates

Otherwise, create a new one?

[akhaliq7]

my question is related more towards matching the number of rows in my dimension table to my fact table just want to know what the best practices someone had suggested in another forum to use an inner join in the data source