Building and customizing solutions using Microsoft 365 Copilot APIs and tools
- Settings required to enable Copilot in embedded Power BI reports via iframe
For secure web or portal embedding (Power BI Service "Embed report Website or portal" scenario):
- The tenant must have Copilot enabled by the Fabric/Power BI admin.
- The workspace that hosts the report must be in Power BI Premium or paid Fabric capacity.
- In the Power BI Service, for each report to be embedded:
- Open the report.
- From the File menu, select Embed report Website or portal.
- In the embed dialog, select the Enable Copilot checkbox.
Once this is done, Copilot is available inside the embedded iframe for that report.
- Scope: enabling Copilot only for demo workspace / selected reports / selected users
From the provided information:
- Copilot can be enabled per embedded report via the Enable Copilot checkbox in the embed dialog.
- Copilot availability is also controlled at the tenant level by administrators via the admin portal.
- Copilot requires Power BI Premium or Fabric capacity in the workspace.
This allows:
- Scoping to a demo workspace by placing only test reports in a Premium/Fabric-backed demo workspace and enabling Copilot there.
- Scoping to selected reports by enabling Copilot only in the embed dialog for those specific reports.
User-level scoping is handled through normal access control (workspace/report permissions, RLS, and tenant-level Copilot enablement). The context does not describe a Copilot setting that targets individual users per report, beyond standard security groups and access control used for governance.
- Impact of tenant/capacity data processing settings on other workspaces/reports
The context states:
- Tenant administrators can enable or disable Copilot through the admin portal.
- Copilot requires an active Copilot tenant switch and Premium/Fabric capacity in the workspace.
Enabling the tenant-level Copilot switch and capacity data processing settings makes Copilot available where prerequisites are met, but Copilot appears in embedded reports only when:
- The workspace is on Premium/Fabric capacity, and
- The Enable Copilot checkbox is selected in the embed dialog for that report.
Therefore, turning on tenant and capacity settings does not automatically enable Copilot for all embedded reports; it enables the capability, which then must be explicitly turned on per report via the embed dialog.
- RLS, identity, and Copilot in embedded iframe
Relevant points from the context:
- In embedded scenarios, Power BI enforces all policies (such as access or RLS) based on the identity or embed token used.
- For "embed for your customers" (App owns data), ISV policy decisions are encrypted in an embed token. Power BI Client APIs automatically append this token as an
Authorization: EmbedTokenheader, and Power BI enforces all policies (access, RLS, OLS) exactly as specified when the token was generated. - When using RLS with embed tokens, the effective identity supplied with the token determines which data is visible.
Copilot in Power BI operates on the data available in the semantic model and report for the current user/session. Because Power BI enforces RLS and object-level security based on the identity or embed token, Copilot only has access to the data that the embedded report exposes for that user. It does not bypass RLS or Azure AD identity; it works within the same security boundaries.
- Validity of the demo workspace + two demo accounts + RLS test
The proposed test setup aligns with recommended practices:
- Use a dedicated demo workspace on Premium/Fabric capacity.
- Configure Row-Level Security so each demo account (or effective identity in embed tokens) can only see its own customer data.
- Embed the report via iframe with Copilot enabled in the embed dialog.
- Verify that prompts to Copilot only return data within the users RLS scope.
This is a valid and appropriate approach to verify that customer data isolation is preserved when Copilot is enabled in embedded reports.
- Additional security checks and limitations before production
Key considerations from the context:
- Governance and phased rollout
- Use security groups and grant access to Copilot only after users are trained on its limitations and use cases.
- Roll out Copilot in phases, starting with test/demo workspaces before production.
- Semantic model preparation
- Ensure proper naming conventions, field descriptions, and good modeling practices.
- Set up linguistic modeling and follow Copilot preparation guidance so outputs are accurate and grounded.
- Business user preparation
- Explain when to use Copilot versus directly using report visuals.
- Overuse of Copilot can increase capacity usage and reduce efficiency.
- Output evaluation and responsible use
- Copilot outputs can be inaccurate or low quality and are nondeterministic.
- Establish internal guidance for validating Copilot responses against trusted data.
- Privacy and security model
- Copilot does not store prompts or responses after the session ends.
- Data stays within the organizations tenant boundary and is not used to train foundation models.
- Tenant admins can centrally enable or disable Copilot.
- Embedded security features
- For App-owns-data embedding, RLS and OLS are enforced via the embed tokens effective identity.
- Assigning users to roles in the Power BI service does not affect RLS/OLS when using embed tokens; ensure the effective identity in tokens is correctly configured.
Before moving to production, recommended checks include:
- Confirm tenant-level Copilot settings and capacity assignments are correct and limited to the intended workspaces.
- Validate RLS and any object-level security thoroughly with multiple test identities/effective identities.
- Review semantic models for PII exposure and ensure RLS/OLS rules prevent cross-customer access.
- Document internal guidance for responsible use and validation of Copilot outputs.
This combination of demo workspace testing, RLS validation, and governance/semantic model preparation is an appropriate and safe approach for introducing Copilot into customer-facing embedded Power BI reports.
References:
- Power BI security
- Embed a report in a secure portal or website
- Copilot in Power BI integration overview
- Generate an embed token
- Privacy, security, and responsible use for Copilot in Power BI
- Security features in Power BI Embedded
- FAQ for Copilot data security and privacy for Dynamics 365 and Power Platform