DP-500 · Question #71
You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements. What should you do?
The correct answer is A. Grant the sales managers the Build permission for the existing Power BI datasets. To enable sales managers to perform ad hoc reporting using existing Power BI datasets, grant them the Build permission on those datasets.
Question
Options
- AGrant the sales managers the Build permission for the existing Power BI datasets.
- BGrant the sales managers admin access to the existing Power BI workspace.
- CCreate a deployment pipeline and grant the sales managers access to the pipeline.
- DCreate a PBIT file and distribute the file to the sales managers.
How the community answered
(70 responses)- A76% (53)
- B3% (2)
- C6% (4)
- D16% (11)
Why each option
To enable sales managers to perform ad hoc reporting using existing Power BI datasets, grant them the Build permission on those datasets.
The Build permission on a Power BI dataset allows users to create new reports, dashboards, and Power BI apps based on that dataset, and to connect to it from Excel or other tools for ad hoc analysis, directly addressing the requirement.
Granting admin access to the workspace provides excessive permissions, including content creation, deletion, and managing access, which is beyond what's needed for ad hoc reporting.
A deployment pipeline is for managing content lifecycle (development, test, production) and is not directly related to enabling end-users for ad hoc reporting.
Distributing PBIT files would require managers to have Power BI Desktop, manage their own data sources, and refresh schedules, which is not an efficient way to enable ad hoc reporting on existing, managed datasets in a workspace.
Concept tested: Power BI dataset Build permission
Source: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions
Topics
Community Discussion
No community discussion yet for this question.