PL-300 Question #355: Real Exam Question with Answer & Explanation

Question

You have a Power BI dataset named Finance that is hosted in a Power BI workspace. The finance team at your company is NOT currently a member of any Power BI workspace roles. You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset. What should you do?

Options

• AGrant the finance team build permissions to the Finance dataset.
• BProvide an Excel workbook that is connected to the Finance dataset.
• CCreate a row-level security (RLS) role and add the finance team to the role as members.
• DGrant the finance team write permissions to the Finance dataset.

Explanation

The 'Analyze in Excel' feature in Power BI requires the user to have Build permission on the dataset. Build permission grants the ability to create new content (pivot tables, reports) connected to the dataset without requiring the user to be a workspace member or have edit access. Option A is therefore correct - granting Build permission is the precise, least-privileged way to enable Excel analysis. Option B (providing a pre-connected workbook) is a workaround, not a scalable permission solution, and the team would not be able to independently connect new workbooks. Option C (RLS role membership) controls what data users can see, not whether they can access the dataset at all - RLS alone does not grant connection access. Option D (Write permission) grants the ability to edit the dataset itself, which is broader than needed and a security over-grant.

No community discussion yet for this question.