nerdexam
Microsoft

PL-300 · Question #160

In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset. You need to allow Power Bi users to export the summarized data used to create the visualizations but…

The correct answer is C. From Power BI Desktop, configure the Report settings for the current file. In Power BI Desktop, under File > Options and Settings > Options > Report Settings (for the current file), there is an 'Export data' section that controls what end users can export. Setting it to 'Summarized data only' allows users to export the aggregated data shown in visuals…

Submitted by takeshi77· Apr 18, 2026Visualize and analyze the data

Question

In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset. You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data. What should you do?

Options

  • AFrom Power BI Desktop, configure the Data Load settings for the current file.
  • BFrom the Power BI service, configure the dataset permissions.
  • CFrom Power BI Desktop, configure the Report settings for the current file.
  • DFrom Power BI Desktop, modify the data source permissions.

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    9% (2)
  • C
    86% (19)

Explanation

In Power BI Desktop, under File > Options and Settings > Options > Report Settings (for the current file), there is an 'Export data' section that controls what end users can export. Setting it to 'Summarized data only' allows users to export the aggregated data shown in visuals but blocks access to the raw underlying rows. Option A (Data Load settings) controls how data is imported, not export behavior. Option B (dataset permissions in the service) controls who can access the dataset, not the type of data they can export. Option D (data source permissions) governs connection credentials, not export restrictions.

Topics

#Data Export Control#Report Settings#Power BI Desktop#Summarized vs. Underlying Data

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice