70-778

You have a table in Power B1 Desktop as shown m the following exhibit. You pivot the columns as shown in the following exhibit. You need to resolve the error in row 3. The solution must preserve all the data. What should you do?A . Change the Data Type of...

DRAG DROP You have a column named phone_number. The values in the columns are in one of the following formats: The values after x in the phone_number column indicate the phone extension. How should you complete the query? To answer, drag the appropriate value to the correct targets. Each value...

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, while others might not have a correct solution. After you...

You plan to create several datasets by using the Power BI service. You have the files configured as shown in the following table. You need to identify which files can be used as datasets, Which two files should you identify? Each correct answer presents pact of the solution NOTE: Each...

You have the following two queries in Power BI Desktop: • A Query named Query 1 that retrieves a table named SM8_ Customers from a Microsoft SQL Server database • A query named Query2 that retrieves a table named Enterprise, Customers from an Oracle database Both tables have the same...

You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data Which data source you should use?A . Microsoft Azure Data Lake StoreB . Microsoft Azure Table StorageC . Microsoft Azure HD lnsightD . Microsoft Azure SQL...

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, while others might not have a correct solution. After you...

HOTSPOT Your company plans to use Power BI for 20 users the sales department. The users will perform the following tasks: • Access a published Power BI app. • Modify reports in an app workspace. • Share dashboards created in My Workspace You need to identify which Power BI licenses...

Note: This question it 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. You...

You have a Power BI report that is configured to use row-level security (RLS). You have the following roles: • A manager role that limits managers to see only the sales data from the stores they manage. • A region role that limits users to see only the data from...