exam questions

Exam PL-900 All Questions

View all questions & answers for the PL-900 exam

Exam PL-900 topic 1 question 63 discussion

Actual exam question from Microsoft's PL-900
Question #: 63
Topic #: 1
[All PL-900 Questions]

HOTSPOT -
You have a Power BI report.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
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
1. Select the ellipsis in the upper-right corner of the visualization.
2. Choose the Export data icon.
3. Power BI exports the data to a .csv file. If you've filtered the visualization, then the app will filter the downloaded data.
4. 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.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Vic_2020
Highly Voted 4 years, 2 months ago
For me the all the answer is YES
upvoted 140 times
catcat567
2 years, 3 months ago
Yes, "If you're interested in seeing behind-the-scenes, the Power BI service lets you display the data that is being used to create a visual in a report. When you select Show as a table, Power BI displays the data below (or next to) the visual." https://docs.microsoft.com/en-us/power-bi/consumer/end-user-show-data
upvoted 7 times
...
Zakriya
3 years, 6 months ago
Yes all should be Yes
upvoted 8 times
...
yassine70
3 years, 7 months ago
for the second question we can use "show as a table" option to view the data behind a visual without exporting the data to a .csv or .xlsx file
upvoted 17 times
yassine70
3 years, 7 months ago
I agree with @Vic_2020; all the answers should be YES
upvoted 7 times
...
...
...
Gowri_Pokuri
Highly Voted 4 years, 2 months ago
All should be YES
upvoted 23 times
...
NEKO_J
Most Recent 2 months, 1 week ago
Yes. Visualization can be exported in a PBI report. Example: a report page can be exported as an image. Yes. Since you create the visualizations in PBI report automatically you can view it there. Common sense. Yes. You can export data to view the supporting data for a KPI in Power BI.
upvoted 1 times
...
dciferit
10 months ago
All answers should be yes You can show the data behind a visual report on your screen without exporting the data. Answer: Yes Explanation: Power BI provides the functionality to see the data behind a visualization directly in the report. By using features like 'Show Data' or 'See Records', you can view the detailed data that is driving a visual without the need to export it.
upvoted 4 times
...
Maniula
1 year, 3 months ago
https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboards "See underlying dataset tables and fields" shows YES for reports.
upvoted 1 times
...
rabis
1 year, 8 months ago
All the answer is YES.
upvoted 1 times
...
SHNH
1 year, 9 months ago
YES YES- 'the Power BI service lets you display the data that is being used to create a visual in a report' YES
upvoted 2 times
...
Eltooth
1 year, 11 months ago
Yes No Yes
upvoted 1 times
...
Sammyenroute01
1 year, 11 months ago
Similar question on MeasureUp and the first two answers are 1) Yes 2) No (for sure)
upvoted 5 times
HN_3532
1 year, 10 months ago
The second question appeared in the Mock Exam and the answer was No
upvoted 4 times
...
...
Kristty
2 years, 5 months ago
The 2. is NO, because we can see the SUMMARIZED data in "Show as a table view", but we can't see the raw data behind the visualization without exporting it. Confirmed in official Microsoft practice exam.
upvoted 12 times
MElokabi
2 years, 1 month ago
But 'show as a table view' doesn't exporting any data so you can see the data
upvoted 1 times
...
...
Contactfornitish
2 years, 6 months ago
Came in exam today, 11/04/2022 Did blunder by selected YNY it seems. 844/1000
upvoted 4 times
...
Toli2
2 years, 6 months ago
i found this on another site. i would also say 3 YES You have a Power BI report. For each of the following statements, select Yes if the statement is true. Otherwise, select No. ✅ Yes ⬜ No - You can export data from a visualization in a Power BI report ✅ Yes ⬜ No - You can show the data behind a visual report on your screen without exporting the data ✅ Yes ⬜ No - You can export data to view supporting data for a KPI
upvoted 6 times
...
easport
2 years, 7 months ago
Verified on exam 17/03/2022
upvoted 1 times
...
DanielPants
2 years, 7 months ago
When users comment "Verified" they're letting us know that this question is indeed on the exam. There are two things we are expecting when we come to sites like this one: 1. The questions will appear on the exam as they appear here. 2. The answers provided are correct. While the "Verified" comments don't speak to the second point; they verify the first. It's valuable to know that the questions on this site are legit on the exam. It's not helpful to post an argumentative comment.
upvoted 17 times
...
hintya
2 years, 9 months ago
Whats with people saying 'Verified'. Even if its appeared in exam on bla bla bla date, how do they know if the answer marked by them is correct?
upvoted 5 times
...
PraveenGabriel
2 years, 11 months ago
Verified - this appeared on 11/13/2021
upvoted 2 times
vtm1
2 years, 9 months ago
who cares dude... your comment I a useful as a chocolate teapot!
upvoted 7 times
...
Tapoja
2 years, 8 months ago
what is the answer
upvoted 1 times
...
...
Nks1999
3 years ago
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data Refer
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago