Exam 70-779 topic 1 question 23 discussion

Actual exam question from Microsoft's 70-779

Question #: 23
Topic #: 1

DRAG DROP -
You have 12 sales reports stored in a folder as CSV files. Each report represents one month of sales data for a year. The reports have the same structure.
You need to analyze the entire year of sales data.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Show Suggested Answer

Suggested Answer:

References:
https://powerpivotpro.com/2017/01/import-csv-files-folder-filenames-excel/ https://www.masterdataanalysis.com/ms-excel/import-csv-files-folder-excel/ https://support.office.com/en-us/article/create-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b

by mohroshdy at Nov. 22, 2019, 12:16 a.m.

Comments

Submit Cancel

mohroshdy

Highly Voted 5 years, 6 months ago

Third answer is "Edit the query, and then click Combine Binaries" because when you open all the CSV files from a folder, all of them will be shown as Binary Content in the power query, so you have to combine them all in one table then you can add this table to the data model.

upvoted 32 times

...

prokocim

Highly Voted 5 years, 3 months ago

Yes, you need to combine binaries but you also need to load to data model. My 3 steps would be: 1. Click From Folder 2. Edit the query and then click Combine Binaries 3. Load to Data Model

upvoted 10 times

Vermonster

5 years, 3 months ago

Can't use Add to Data Model from the Power PIvot tab because that only adds a table in the Excel spreadsheet. Full answer doesn't seem possible with 3 options

upvoted 2 times

...

CDL

Most Recent 4 years, 8 months ago

Tested. 1. Get Data from folder 2. Transform Data -> (content) “Combine” 3. Load to Data Model

upvoted 2 times

...

Rebaccas

4 years, 12 months ago

1. Click From CSV, and then select the first file in the folder; 2. Edit the query, and then click Combine Binaries; 3. From the Power Pivot ta, click Add to Data Model https://www.excel-university.com/pivottable-from-many-csv-files/

upvoted 1 times

r8d1

4 years, 11 months ago

thanks for the link, but i still think 1. create new query 2. select Folder 3. Combine binaries

upvoted 3 times

...

Patterns

5 years ago

Definitely, 1. From Data Tab, create a new qury 2. Click from folder, then add the folder path. 3.Edit the query, and then click combine binaries. ....Tested and trusted

upvoted 9 times

...

irfanarifhussain

5 years, 4 months ago

yes > Third answer is "Edit the query, and then click Combine Binaries"

upvoted 2 times

...