Question 460
In a Microsoft Power BI project, A report has sensitive personal data and its owner wants authorized viewers to see aggregated figures but not export underlying rows. Choose the most defensible solution.
Explanation
Correct Answer
This directly addresses the stated constraint. Export restrictions must be evaluated together with model permissions and sensitivity. Confirmation: Authorized users view aggregates but restricted export options do not expose row-level personal data.
Incorrect Answers
Publishing to the web exposes information publicly and is not suitable for a private audience. The specific problem here is that hiding a raw data table in the model alone is not a comprehensive export security boundary.
Granting all readers Contributor access allows modification of workspace assets. The specific problem here is that hiding a raw data table in the model alone is not a comprehensive export security boundary.
Sharing the entire workspace as Admin to grant one report view exposes unrelated assets. The specific problem here is that hiding a raw data table in the model alone is not a comprehensive export security boundary.