Power BI - Data Cleaning with Power Query
Why does Power Query automatically promote headers when importing from Excel, but not always from CSV files?
Why does Power Query automatically promote headers when importing from Excel, but not always from CSV files?
hard📝 Conceptual Q10 of 15
Step-by-Step Solution
Solution:
Step 1: Understand file format differences
Excel files contain metadata that identifies headers, so Power Query promotes them automatically.Step 2: CSV files lack header metadata
CSV files are plain text without metadata, so Power Query treats all rows as data unless told otherwise.Final Answer:
Excel files store header metadata; CSV files do not -> Option DQuick Check:
Excel has header metadata; CSV does not [OK]
Quick Trick: Excel files include header info; CSV files don't [OK]
Common Mistakes:
- Thinking CSV files never have headers
- Assuming Power Query can't read CSV files
- Believing headers are fixed in Excel only
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