You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd.You create a new Power BI Desktop model that uses 120 tables from SQLDev.You plan to publish the Power BI file to the Power BI service.You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort.What should you do from Query Editor before you publish the model?
Note: This question is a part of a series of questions that present 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 exactly the same in each question in this series.Start of repeated scenarioYou have a Microsoft SQL Server database that contains the following tables.The following columns contain data information:Date[Month] in the mmyyyy formatDate[Date_ID] in the ddmmyyyy formatDate[Date_name] in the mm/dd/yyyy formatMonthly_returns[Month_ID] in the mmyyyy formatThe Order table contains more than one million rows.The Store table has relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.You plan to use Power BI desktop to create an analytics solution for the data.End of repeated scenario.You plan to create a chart that displays total Order [Order_amount] by Store [Name].You need to modify the model to ensure that you can create the chart.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables:Product (Product_id, Producct_Name)Sales (Order_id, Order_Date, Product_id, Selasperson_id, Sales_Amount)Salesperson (Salesperson_id, Salesperson_name, address)The model has the following relationships:Sales to ProductSales to SalespersonYou create a new Power BI file and import the Power Pivot model.You need to ensure that you can generate a report that displays the count of products sold by each salesperson.What should you do before you create the report?
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an app workspace that contains a report. The report contains sensitive data.You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.Solution: Configure the app workspace to be read-only for members and to run in a shared capacity.Does this meet the goal?
You have two tables named CustomerVisits and Date in a Power BI model.You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.You need to fix the report to display the correct data for each month.What should you do?