Analyzing and Visualizing Data with Microsoft Power BI — Question 131

You plan to use Power BI Desktop to import 100 CSV files.
The files contain data from different stores. The files have the same structure and are stored in a network share.
You need to import the CSV files into one table. The solution must minimize administrative effort.
What should you do?

Answer options

• A. Add a folder data source and use the Combine Files command.
• B. Add a folder data source and use the Merge Queries command.
• C. Add a Microsoft Excel data source and use the Merge Queries command.
• D. Add text/CSV data sources and use the Append Queries command.

Correct answer: A

Explanation

The correct answer is A because using the Combine Files command allows you to efficiently consolidate multiple CSV files from a folder into a single table, minimizing manual effort. Option B is incorrect as the Merge Queries command is used for combining different datasets rather than files within the same structure. Options C and D do not apply since they either involve incorrect data sources or methods that do not optimize the import process for multiple files.