QUESTION: 25

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.

You do not have permissions to the file.
An incorrect privacy level was used for the data source.
The file is locked.
The referenced file was moved to a new location.

Answer(s): A,D

Show Answer Next Question

QUESTION: 26

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?

Select Replace Errors.
Edit the query in the Query Errors group.
Select Remove Errors.
Select Keep Errors.

Answer(s): A

Show Answer Next Question

QUESTION: 27

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?

Apply the Parse function from the Data transformations options to the Logged column.
Change the data type of the Logged column to Date.
Split the Logged column by using at as the delimiter.
Create a column by example that starts with 2018-12-31.

Answer(s): C

Show Answer Next Question

QUESTION: 28

DRAG DROP (Drag and Drop is not supported)
You have two Microsoft Excel workbooks in a Microsoft OneDrive folder.
Each workbook contains a table named Sales. The tables have the same data structure in both workbooks.
You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table. The solution must ensure that you can publish a separate report and dataset.
Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the correct files. Each mode may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.