Question

You are building a star schema in Power Query. Your Product dimension table was loaded from a spreadsheet where the same ProductID appears on multiple rows because a maintenance log was accidentally included. Before you can create a one-to-many relationship from Product to the Sales fact table, Power BI reports the relationship cannot be created because the key on the one side is not unique. Which Power Query action best resolves this while keeping the dimension usable?

Accepted Answer

Use Remove Duplicates on the ProductID column after selecting the columns that define a unique product, so each ProductID appears only once.

Answer

Set the ProductID column data type to Text so Power BI treats the values as unique strings.

Answer

Group by ProductID and sum all remaining columns to collapse the rows into one.

Answer

Mark the relationship as many-to-many and enable cross-filtering in both directions.