You are creating a Power BI model that contains a table named Store. Store contains the following fields.You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?
You have a Microsoft Excel file on a file server.You create a Power BI report and import a table from the Excel file.You publish the report.You need to ensure that the data refreshes every four hours.What should you do first?
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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.Solution: You create a new query that references DataSourceExcel.Does this meet the goal?
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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.Solution: You add a Power Apps custom visual to the report.Does this meet the goal?
What is the minimum number of datasets and storage modes required to support the reports?