What should you do before you publish to Power BI?

You have an Excel workbook that contains two tables named User and Activity. You plan to publish the workbook to the Power BI service. Users will use Q&A in the Power BI service to perform natural language queries. You need to ensure that the users can query the term employee and receive results from the […]

Read More

You open C:\Data\Data.xlsx in Excel.

You open C:\Data\Data.xlsx in Excel. When you attempt to publish the file to Microsoft Power BI, you receive the following error message: “We couldn’t publish to Power B I. Make sure your workbook issaved as an Excel file (.xlsx or .xlsm) and is not password protected.” You need to ensure that you can publish the […]

Read More

Which field should you use for each area?

DRAG DROP You need to create a PivotChart as shown in the exhibit. (Click the Exhibit button.) Exhibit: Which field should you use for each area? To answer, drag the appropriate fields to the correct areas. Each field may be used once, more than once, or not at all.You may need to drag the split […]

Read More

In which area is Product and in which area is SalesAmount?

DRAG DROP You create the PivotChart shown in the exhibit. (Click the Exhibit button.) Exhibit: In which area is Product and in which area is SalesAmount? To answer, drag the appropriate fields to the correct areas. Each field may be used once, more thanonce, or not at all. You may need to drag the split […]

Read More

What should you do?

Start of repeated scenario. You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit. (Click the Exhibit button.) Data Sample exhibit:     The data model is […]

Read More

Which Excel formula should you use?

Start of repeated scenario. You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit. (Click the Exhibit button.) Data Sample exhibit:     The data model is […]

Read More

How should you complete the DAX formula?

HOTSPOT Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series. Start of repeated scenario. You […]

Read More

Which three actions should you perform in sequence?

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 […]

Read More

What should you do first?

You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.) Exhibit: You need to transform the data by using Query Editor. What should you do first? A. From the Data tab, click Flash Fill B. From the Insert tab, click Store C. From the Data tab, click From Table/Range D. From the […]

Read More