🔥 3-day streak
Microsoft Power BI Data Analyst2 / 205
Question 2 of 205
You import a Product dimension table into Power Query. The source has no reliable unique identifier because the natural business key (ProductCode) contains occasional duplicates caused by legacy data entry, and you must relate this dimension to a large Sales fact table. You want a guaranteed unique key to use as the one-side of the relationship without altering the existing ProductCode values. What is the most appropriate step to take in Power Query?
Reviewed for accuracy · Report an issueNext question