Question

You are preparing a customer table in a Dataflow Gen2 that loads into a Fabric Lakehouse. The source system occasionally sends the same customer record multiple times, differing only by a LastModified timestamp. The business requires that only the most recent version of each customer (based on CustomerID) survives in the destination table. Which sequence of transformations most reliably achieves this in Power Query?

Accepted Answer

Sort the rows by LastModified in descending order, then use Remove Duplicates on the CustomerID column.

Answer

Use Remove Duplicates on the CustomerID column, then sort by LastModified descending.

Answer

Group by CustomerID and select the Max aggregation on CustomerID, then merge back all other columns.

Answer

Use Keep Duplicates on the CustomerID column to retain the records that repeat.