Power BI - Getting Data
You want to import multiple CSV files from a folder and combine them into one table in Power BI. Which approach is best?
You want to import multiple CSV files from a folder and combine them into one table in Power BI. Which approach is best?
hard📝 Scenario Q9 of 15
Step-by-Step Solution
Solution:
Step 1: Use the Folder data source in Power BI
Choose 'Get Data' > 'Folder' to select a folder containing multiple CSV files.Step 2: Combine files using Power Query's built-in combine binaries feature
Power Query automatically combines files with the same structure into one table.Final Answer:
Use 'Get Data' > 'Folder', then combine files using Power Query's combine binaries feature -> Option BQuick Check:
Combine multiple CSVs via Folder and combine binaries = D [OK]
Quick Trick: Use Folder import and combine binaries to merge CSV files easily [OK]
Common Mistakes:
- Importing files separately and merging with DAX
- Copy-pasting data manually
- Ignoring smaller files
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes