Microsoft PL-300

Topic 1: Prepare the data

From Power Query Editor, you attempt to execute a query and receive the following error message.

Datasource.Error: Could not find file.

What are two possible causes of the error? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Topic 1: Prepare the data

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

• If the discount column returns an error, a discount of 0.05 must be used.

• All the rows of data must be maintained.

• Administrative effort must be minimized.

What should you do in Power Query Editor?

Topic 1: Prepare the data

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

Topic 1: Prepare the data

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

Topic 1: Prepare the data

HOTSPOT

You have a folder that contains 50 JSON files.

You need to use Power BI Desktop to make the metadata of the files available as a single dataset. The solution must NOT store the data of the JSON files.

Which type of data source should you use, and which transformation should you perform? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.