Microsoft
70-778 · Question #98
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…
The correct answer is A. Add a folder data source and use the Combine Files command. https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries
Consume and Transform Data by Using Power BI Desktop
Question
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?
Options
- AAdd a folder data source and use the Combine Files command.
- BAdd a folder data source and use the Merge Queries command.
- CAdd a Microsoft Excel data source and use the Merge Queries command.
- DAdd text/CSV data sources and use the Append Queries command.
How the community answered
(19 responses)- A79% (15)
- B5% (1)
- C5% (1)
- D11% (2)
Explanation
https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries
Topics
#folder data source#combine files#CSV import#data ingestion
Community Discussion
No community discussion yet for this question.