Question 8

Explanation

Note: Power BI dashboards and Power BI datasets are components of the Power BI service. You cannot view the Power BI dataset in Desktop unless you go to the task manager. You can view only the Power BI report on both Desktop and service.

Statement a:

The given statement refers to the ability to filter data. You can filter data in Power BI reports (either Desktop or service).

In the Power BI report, click Edit to apply filters.

Shown below is the financial report with filters applied for a specific year.

Whereas in the Power BI dashboard, you can apply filters only to a specific dashboard tile (not to all the tiles in the dashboard) in focus mode.

Select any dashboard tile and click Open in focus mode.

You can see only the fields (Sales, Country) used in the dashboard tile as filters.

Quick Preview:

Reference Link: https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboards#dashboards-versus-reports

Since we need to view all the visuals for a specific year, a -> Power BI reports.

Further, you can only view tables and fields in the dataset, not the visuals.

Statement b:

We can create dashboard alerts on an individual tile to notify if the metric (Net Profit) goes below a specific value.

You cannot create alerts on individual visuals in Power BI reports.

Reference Link: https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

So, b -> Power BI dashboards.

Statement c: We can use the Analyze in Excel feature in both datasets and reports to export and analyze the data in an Excel workbook. The Analyze in Excel feature is not available for Power BI dashboards.

Quick Preview:

Reference Link: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#connect-to-power-bi-data-with-analyze-in-excel

So, c -> Power BI reports or Power BI dataset.

Only option B has the right combination of statements. Option B is the correct answer.