Forum Discussion
Cleaning a dimension table correctly
akhaliq7 , Remove duplicates. Add Index columns
Watch Video 2,3,4 in this series
https://www.youtube.com/playlist?list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
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
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?
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
