Microsoft Certified: Power BI Data Analyst AssociatePrepare the dataEasy
A Power BI developer is importing data from a folder containing multiple CSV files, each representing sales data for a different region. All CSV files have the same structure and column headers. The developer needs to combine all these files into a single table in Power Query. Which option in the 'Get Data' interface is specifically designed for this scenario?
- AWeb
- BFolder
- CText/CSV
- DSQL Server database
Show answer & explanationAnswer & explanation
Correct answer: B. Folder
The 'Folder' connector in Power Query is specifically designed to combine multiple files with the same structure from a specified directory. It automates the process of loading and appending data from each file into a single table.
Why the other options are wrong
- A. Web is for importing data from online sources or APIs.
- C. Text/CSV is for importing a single CSV file, not combining multiple.
- D. SQL Server database is for connecting to relational databases.
Folder Connector (Power Query)
A Power Query connector used to import and combine data from multiple files within a specified folder, assuming they have a consistent structure.
- Automates combining files from a directory.
- Files must typically have the same structure and headers.
- Can handle various file types (CSV, Excel, JSON, etc.) within the folder.
Memory trick: Many files in a folder, use the Folder connector to unite them all.