Power BI - Data Cleaning with Power Query
Which Power Query M function is used to promote headers in a table?
Which Power Query M function is used to promote headers in a table?
easy📝 Formula Fix Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall Power Query M functions for header promotion
The function to promote headers is Table.PromoteHeaders.Step 2: Differentiate from other functions
Table.RenameColumns changes column names manually, RemoveRows deletes rows, Sort orders rows, none promote headers.Final Answer:
Table.PromoteHeaders -> Option AQuick Check:
Promote headers function = Table.PromoteHeaders [OK]
Quick Trick: Use Table.PromoteHeaders to set first row as headers [OK]
Common Mistakes:
- Using Table.RenameColumns instead
- Confusing with row removal or sorting
- Misspelling the function name
Master "Data Cleaning with Power Query" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes