PL-300 Practice Online

You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that bar chart displays on Dashboard1. What should you do?

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM? 

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 have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains

several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and

then click Upload

Does this meet the goal?

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. You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information: - Date[Month] in the mmyyyy format - Date[Date_ID] in the ddmmyyyy format - Date[Date_name] in the mm/dd/yyyy format - Monthly_returns[Month_ID] in the mmyyyy format The Order table contains more than one million rows. The Store table has a 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. You need to create a relationship between the Monthly_returns table and Date[Date_ID]. What should you do before you create the relationship?