Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution,…
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…
You open C:DataData.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 BI. Make sure your workbook is saved as an Excel file (xlsx or…
You have an Excel workbook query that loads data to a worksheet and the data model. You need to ensure that the data is refreshed whenever you open the workbook. What should you do? A. From the File tab, click…
You need to create a PivotChart that has a filter as shown in the following exhibit. What should you do first? A. From the model, create a measure B. From Query Editor, create a function C. From the model, create…
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…
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…
You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model. You discover that new rows were added to the tables in Azure SQL Database. You need to ensure that…
You have the following table. You plan to use [Month Name] as the axis in a PivotChart. You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically by default. What should you…
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…