What will happen if you apply Table.PromoteHeaders on a table where the first row contains duplicate values like {"ID", "ID"}?

medium📝 dax lod result Q5 of 15

Power BI - Data Cleaning with Power Query

What will happen if you apply Table.PromoteHeaders on a table where the first row contains duplicate values like {"ID", "ID"}?

AThe columns will be renamed with suffixes to avoid duplicates

BAn error will occur due to duplicate column names

CThe second "ID" column will be removed automatically

DThe function will ignore duplicates and keep both columns named "ID"

Step-by-Step Solution

Solution:

Step 1: Understand behavior with duplicate headers
Power Query automatically renames duplicate headers by adding suffixes like "ID.1" to avoid conflicts.
Step 2: Confirm no error or removal occurs
It does not throw an error or remove columns; it adjusts names to keep all columns.
Final Answer:
The columns will be renamed with suffixes to avoid duplicates -> Option A
Quick Check:
Duplicate headers get renamed with suffixes [OK]

Quick Trick: Duplicate headers get renamed with suffixes automatically [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes