PL-900 Microsoft Exam Lab Questions

Box 1: Yes

If you'd like to see the data that Power BI uses to create a visualization, you can display that data in Power BI. You can also export that data to Excel as an .xlsx or .csv file. The option to export the data requires a Pro or Premium license and edit permissions to the dataset and report.

Note: Export data from a Power BI dashboard

Select the ellipsis in the upper-right corner of the visualization.

Choose the Export data icon.

Power BI exports the data to a .csv file. If you've filtered the visualization, then the app will filter the downloaded data.

Your browser will prompt you to save the file. Once saved, open the .csv file in Excel.

Box 2: No

Underlying data: Select this option if you want to see the data in the visual and additional data from the model (see chart below for details). If your visualization has an aggregate, selecting Underlying data removes the aggregate. When you select Export, Power BI exports the data to an .xlsx file and your browser prompts you to save the file. Once saved, open the file in Excel.

Box 3: Yes

A KPI dataset needs to contain goal values for a KPI. If your dataset doesn't contain goal values, you can create them by adding an Excel sheet with goals to your data model or PBIX file.

Note: A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.

Box 1: Report

Reports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc.

Box 2: Dashboard

Dashboards are a business key performance indicator view where it displays key values that can change business profits and can be glanced at one screen.

Box 3: Report

Power BI dashboards cannot slice and dice, but reports have many ways to filter and slice.

Note: Power BI dashboards are one placeholder to display the most important decision-making facts to run a business. But reports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc. Reports are based on one dataset or one business unit data for example reports of a store belonging to California.

Box 1: Gallery

A Gallery control can show multiple records from a data source, and each record can contain multiple types of data. For example, a Gallery control can show multiple contacts with each item showing contact information that includes a name, an address, and a phone number for each contact.

Box 2: Meeting-screen template

In a canvas app, add a meeting screen that lets users create and send meeting requests from their Office 365 Outlook accounts. Users can search for attendees in their org and add external email addresses. If your tenant has meeting rooms built into Outlook, users can select a location as well.

Box 3: Image

If you add one or more Image controls to your app, you can show individual images that aren't part of a data set, or you can incorporate images from records in data sources.