Analyzing Data with Microsoft Power BI (legacy) — Question 8

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

Answer options

• A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
• B. Remove the Subject and Body columns during the import.
• C. From Model view, set the Subject and Body columns to Hidden.

Correct answer: B

Explanation

The correct answer is B because removing the Subject and Body columns from the data import ensures that sensitive information is not included in the report, thereby preventing recipients from reading the analyzed emails. While A proposes using row-level security, it does not address the issue of minimizing model size or protecting the email content effectively. Option C only hides the columns but does not prevent their data from being part of the model.