You have a Power BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset. You grant the users the Build permissi

The correct answer is C. For the report, change the Export data setting to None.. Build permission on a dataset allows users to connect to it directly from Excel via 'Analyze in Excel,' which is the desired behavior. However, if the report's Export data setting allows exporting, users could also extract data through the report visuals. Setting Export data to N

Submitted by viktor_hu· Apr 18, 2026Manage and secure Power BI

Question

You have a Power BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset. You grant the users the Build permission for the dataset. What should you do next?

Options

ACertify the dataset used by the report.
BChange the default visual interaction for the report.
CFor the report, change the Export data setting to None.
DFor the report, change the Export data setting to Summarized data, data with current layout and

How the community answered

(15 responses)

B
7% (1)
C
80% (12)
D
13% (2)

Explanation

Build permission on a dataset allows users to connect to it directly from Excel via 'Analyze in Excel,' which is the desired behavior. However, if the report's Export data setting allows exporting, users could also extract data through the report visuals. Setting Export data to None on the report removes that pathway, ensuring the only way to work with the data in Excel is by connecting directly to the dataset. Certifying the dataset or changing visual interactions does not restrict data export paths.

Topics

#Report Security#Data Export Control#Power BI Service Configuration

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice