Microsoft Power BI Data Analyst — Question 16

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?

Answer options

• A. Grant the finance team build permissions to the Finance dataset.
• B. Provide an Excel workbook that is connected to the Finance dataset.
• C. Create a row-level security (RLS) role and add the finance team to the role as members.
• D. Grant the finance team write permissions to the Finance dataset.

Correct answer: A

Explanation

The correct answer is A because granting build permissions allows the finance team to connect to and analyze the dataset in Excel. Option B does not enable ongoing access to the dataset, while Option C is more about data security than enabling analysis. Option D unnecessarily grants write permissions, which is not needed for analysis purposes.