Question

You are building a Product dimension table in Power Query from a source that repeats each product on every order line. The table contains columns ProductID, ProductName, and Category, but ProductID appears many times because the extract was taken from the sales transactions. Before loading this as a dimension table, you need each ProductID to appear exactly once so it can serve as the 'one' side of a one-to-many relationship. Which Power Query action correctly produces a clean dimension table?

Accepted Answer

Select the ProductID column and use Remove Duplicates

Answer

Select all columns and use Remove Duplicates

Answer

Group By ProductID with no aggregation and expand

Answer

Use Remove Blank Rows on the entire table