PL-300 Exam Question 91
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: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?
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: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?
PL-300 Exam Question 92
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
PL-300 Exam Question 93
You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.
What should you do?
What should you do?
PL-300 Exam Question 94
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
* Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
* Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
* Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
* Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
PL-300 Exam Question 95
You embed a Power BI report in a Microsoft SharePoint Online page.
A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: "This content isn't available".
User1 is unable to view the report.
You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.
You need to ensure that User1 can view the report form SharePoint Online.
What should you do?
A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: "This content isn't available".
User1 is unable to view the report.
You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.
You need to ensure that User1 can view the report form SharePoint Online.
What should you do?