This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Enhance reports for usability and storytelling
      --> Configure Export Settings

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

---

Question 1

A user exports data from a table visual and receives only aggregated values instead of individual rows. What is the most likely reason?

A. Row-Level Security is filtering the data
B. The visual is using a calculated column
C. Export of underlying data is disabled
D. The dataset is using DirectQuery

Correct Answer: C

Explanation:
When underlying data export is disabled, Power BI allows only summarized data to be exported. This is commonly used to prevent access to row-level data.

---

Question 2

Which export option preserves visual formatting but removes interactivity?

A. Export data to Excel
B. Export summarized data
C. Export as PDF
D. Analyze in Excel

Correct Answer: C

Explanation:
Exporting to PDF preserves layout and formatting but results in a static, non-interactive file.

---

Question 3

A report author disables export options for a visual, but users can still export data in the Power BI Service. What is the most likely cause?

A. Dataset permissions override visual settings
B. Row-Level Security is disabled
C. Visual interactions are enabled
D. The report is using Import mode

Correct Answer: A

Explanation:
Dataset and tenant-level settings can override visual-level restrictions, allowing exports even if a visual is configured to restrict them.

---

Question 4

Which export behavior always respects Row-Level Security (RLS)?

A. Export summarized data
B. Export underlying data
C. Export to Excel
D. All export methods

Correct Answer: D

Explanation:
All export methods in Power BI respect RLS, ensuring users only export data they are authorized to see.

---

Question 5

An organization wants to prevent users from exporting row-level data across all reports. Where should this be configured?

A. Visual formatting pane
B. Report settings in Power BI Desktop
C. Dataset settings in Power BI Service
D. Power BI Admin portal

Correct Answer: D

Explanation:
The Power BI Admin portal allows administrators to enforce export restrictions tenant-wide, overriding report and dataset settings.

---

Question 6

Which export option allows users to include current slicer and filter selections?

A. Export summarized data
B. Export report to PDF
C. Export underlying data
D. Copy visual as image

Correct Answer: B

Explanation:
When exporting a report to PDF, users can choose to export with current values, which includes applied filters and slicers.

---

Question 7

A user wants to export data for further analysis while keeping the original Power BI dataset connected. Which option should they use?

A. Export underlying data
B. Export summarized data
C. Analyze in Excel
D. Export to PowerPoint

Correct Answer: C

Explanation:
Analyze in Excel maintains a live connection to the Power BI dataset, enabling dynamic analysis without extracting the data.

---

Question 8

What happens if underlying data export is disabled but summarized data export is enabled?

A. Users cannot export data
B. Users can export aggregated values only
C. Users can export only visuals
D. Users can export row-level data

Correct Answer: B

Explanation:
With underlying data disabled, Power BI allows exports of aggregated values only, matching what is displayed in the visual.

---

Question 9

Which export format is best suited for executive summaries and board-level reporting?

A. Excel (.xlsx)
B. CSV
C. PDF
D. Analyze in Excel

Correct Answer: C

Explanation:
PDF exports are ideal for executive reporting because they preserve formatting and are easy to distribute and consume.

---

Question 10

A report uses sensitivity labels that restrict data sharing. What impact do these labels have on exports?

A. They remove all export options
B. They allow exports but remove filters
C. They may restrict or block exports based on policy
D. They only affect sharing, not exporting

Correct Answer: C

Explanation:
Sensitivity labels can enforce data protection rules, including restricting or disabling export options depending on organizational policies.

---

Final Exam Tip

For PL-300, always think in this order when troubleshooting exports:

Tenant → Dataset → Report → Visual

The most restrictive setting wins, and security is never bypassed.

---

Go back to the PL-300 Exam Prep Hub main page