In which order should you perform the actions?

DRAG DROP

You store data about products in two Microsoft Excel worksheets.

The data contains duplicate rows.

You need to consolidate data from the two worksheets into a Microsoft Dataverse custom table.

In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

Explanation:

Graphical user interface, text, application, email

Description automatically generated

Step 1: Upload the worksheets to OneDrive

A data source needs to be specified. The data needs to be available.

Step 2: Create a dataflow

Step 3: Create queries for the worksheets

You can shape your data selection into a form that works best for your table using a Power Query editing experience, similar to the Power Query Editor in Power BI Desktop.

Step 4: Add conditional columns to perform checks on the data

Step 5: Append the output of the queries