Exam 70-778 topic 1 question 64 discussion

Actual exam question from Microsoft's 70-778

Question #: 64
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

by Dibassi at Sept. 18, 2019, 6:40 p.m.

Comments

Submit Cancel

jas0798

1 year, 10 months ago

if I need to choose 2 correct options, can I choose A and D?

upvoted 1 times

...

CDL

4 years, 7 months ago

A is correct, Folder, Combine --->Append

upvoted 2 times

...

AxxxD

4 years, 8 months ago

Combine: It only appears in the case of the 'Folder' data source used to combine multiple files at one go; (it is the correct answer) Append: Used when data already reside in Power query editor Merge: It's simply a join operation on tables resides in Power query editor

upvoted 3 times

...

r8d1

5 years ago

For this question the goal is to minimise effort, so Get Data > Folder provides the option to Combine. You would need to >Transform Data, then Merge in Query Editor (i.e. more effort).

upvoted 2 times

cromastro

4 years, 10 months ago

No. Merge is way different. Merge combines files when you need more columns. You are thinking Append. Use Append when you have the same columns and want to add rows.

upvoted 1 times

...

Dibassi

5 years, 9 months ago

When should I use Combine vs append?

upvoted 1 times

mirzotti

5 years, 7 months ago

Combine is used when using the Folder option to load all files in the folder. Append is used to combine/append already loaded files or availble queries in Query Editor.

upvoted 5 times

JohnFan

5 years, 6 months ago

Combine is used when import data https://support.office.com/en-us/article/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4 Append/Merge is used to append/merge already loaded files or availble queries in Query Editor. https://radacad.com/append-vs-merge-in-power-bi-and-power-query

upvoted 8 times

...