PL 400 Power BI Integration 5 — Questions and Answers
Question 1: A developer embeds a Power BI report in a Teams tab using the Teams Power BI app. A user reports they cannot see the report. What should be checked first?
- The user's Teams license tier
- Whether the report is published to a workspace the user has access to (Correct answer)
- The Teams app permissions in the admin center
- Whether Power BI is enabled in the Microsoft 365 tenant
Correct answer: Whether the report is published to a workspace the user has access to
The most common cause is that the user is not a member of the workspace or doesn't have access to the Power BI app containing the report.
Question 2: Which API endpoint is used to retrieve a list of reports in a Power BI workspace using the Power BI REST API?
- GET /v1.0/myorg/groups/{groupId}/reports (Correct answer)
- GET /v1.0/myorg/datasets/{datasetId}/reports
- GET /v1.0/myorg/reports?workspaceId={id}
- GET /v1.0/myorg/workspaces/{id}/listreports
Correct answer: GET /v1.0/myorg/groups/{groupId}/reports
The endpoint GET /v1.0/myorg/groups/{groupId}/reports returns all reports in a specified workspace (group) via the Power BI REST API.
Question 3: A developer needs to allow external guest users (Azure AD B2B) to view an embedded Power BI report. What configuration is required in the Power BI tenant settings?
- Enable 'Export to Excel' for guest users
- Enable 'Allow Azure Active Directory guest users to access Power BI' (Correct answer)
- Set the workspace to public visibility
- Enable 'Publish to web' for the report
Correct answer: Enable 'Allow Azure Active Directory guest users to access Power BI'
The tenant admin must enable 'Allow Azure Active Directory guest users to access Power BI' in the admin portal before B2B guests can view content.
Question 4: In Power BI, what is the purpose of a 'service principal profile' when embedding reports for customers at scale?
- It allows each customer tenant to have isolated embed tokens under one service principal (Correct answer)
- It stores customer-specific Power BI Pro licenses
- It maps DAX roles to Azure AD groups
- It manages gateway connections for each customer
Correct answer: It allows each customer tenant to have isolated embed tokens under one service principal
Service principal profiles (multitenancy) allow a single Azure AD service principal to manage multiple isolated customer workspaces with separate embed tokens.
Question 5: A developer uses Power BI Desktop's 'Publish to Power BI' feature but the target workspace is grayed out. What is the most likely cause?
- The workspace is in read-only mode
- The user does not have at least Contributor role in the workspace (Correct answer)
- The dataset is too large for the workspace
- The workspace is on shared capacity
Correct answer: The user does not have at least Contributor role in the workspace
Publishing to a workspace requires at least the Contributor role; Viewer role is insufficient for publishing new or updated content.
Question 6: Which Power Automate connector action is used to trigger a Power BI goal (scorecard metric) status update based on business logic?
- Update a goal value in a scorecard (Correct answer)
- Refresh a dataset
- Run a query against a dataset
- Export report
Correct answer: Update a goal value in a scorecard
The 'Update a goal value in a scorecard' action in the Power BI connector allows flows to programmatically update scorecard metric values and statuses.
Question 7: A developer wants to enforce that an embedded Power BI report always applies a specific RLS role regardless of the authenticated user. Which embed token parameter accomplishes this?
- effectiveIdentity with a username and roles array (Correct answer)
- RLSFilter in the embed configuration
- datasetFilterOverride in the report settings
- securityFilter in the GenerateToken request body
Correct answer: effectiveIdentity with a username and roles array
The effectiveIdentity object in the GenerateToken request specifies a username and roles array, forcing the embed session to apply the specified RLS roles.
PL 400 Power BI Integration 5
A developer embeds a Power BI report in a Teams tab using the Teams Power BI app.
A user reports they cannot see the report.
What should be checked first?