A Copilot Studio audit trail is a structured, tamper-resistant log of every prompt, agent response, tool call, and data source read your agent produces. Follow this guide to configure that log so any auditor can reconstruct what the agent did, when, and why.
This guide is part of our AI agent how-to series. The steps below apply to any Copilot Studio agent running in a Dataverse-enabled environment.
ConversationTranscript records. To also send real-time telemetry to Azure, enter your Application Insights connection string under Settings > Advanced > Azure Application Insights. Both destinations can be active simultaneously. See the official Microsoft Copilot Studio transcripts documentation for the current field reference.
ConversationTranscript rows. The service account that writes transcripts should not have delete permission on that table. Set the retention period in Dataverse or in a Log Analytics Workspace to cover the full audit window your regulation requires. Financial services and healthcare organizations typically need five to seven years. HITL checkpoint: before go-live, a compliance officer or data protection lead must review and sign off on the storage location, access control list, and retention period in writing. No agent should reach production until that approval is on record.
ConversationTranscript table and, if in use, the Application Insights workspace. Build a report filterable by user ID or session ID that shows the chronological sequence of prompts, responses, actions called, and data sources read. The goal is that a compliance team member can enter a case reference and get a complete, readable account of every related agent interaction within minutes.
Two decisions determine whether your audit trail holds up under scrutiny: where records are stored and who can modify them. The table below compares the main storage options for a Copilot Studio audit trail:
| Storage target | Strengths for audit | Watch out for |
|---|---|---|
| Dataverse | Native to Copilot Studio; row-level security; queryable by Power BI directly | Retention ceiling varies by plan; bulk export required for long-term archival |
| Azure Application Insights | Real-time telemetry; Azure Monitor alerts; configurable retention up to 730 days | Queries require KQL; not a compliance-grade standalone store without Log Analytics Workspace export |
| Microsoft Purview | Retention policies, sensitivity labeling, eDiscovery; built for regulated environments | Additional licensing cost; setup complexity increases for smaller teams |
For most regulated deployments, Dataverse works as the operational store with a scheduled export to Azure Blob Storage or a Log Analytics Workspace for long-term retention. Microsoft Purview then applies retention policies and sensitivity labels at the storage layer.
On access control: the agent service account should have write-only permission on the transcript table, compliance reviewers should have read-only permission, and no account should have delete permission outside an approved retention-expiry process. Document the access matrix and attach it to your audit policy document before going live.
The most common failure mode is logging only the chat text while tool calls and data reads go unrecorded. A transcript that shows the agent replied “your application has been reviewed” tells an auditor nothing about which records the agent read, which rules it applied, or what a connected Power Automate flow did with that data. Regulators reviewing AI decisions will ask for the full execution path, not just the output text.
Retention is the second problem. Copilot Studio's default Dataverse transcript retention may not cover your regulatory window. If you do not set and document a retention period before go-live, you may be unable to produce records for an audit that covers any period before the policy was in place.
PII in transcripts is the third risk. Users include names, account numbers, and other personal data in prompts regularly. Storing that data in a plain-text transcript table without access controls or a redaction process creates a separate data protection obligation. Agree on a redaction or pseudonymization approach with your data protection team before enabling logging, not after the first data subject access request arrives.
QServices' AI Governance Consulting practice designs audit logging and HITL frameworks for Copilot Studio agents in regulated industries. A typical engagement covers audit record schema design, Dataverse or Application Insights routing, Power BI compliance dashboard build, access control configuration, and a review process your team can run independently.
Engagements run 4 to 12 weeks depending on scope. Governance-focused projects start around $15,000 for a scoped setup and reach $90,000 for enterprise rollouts with multi-environment deployments and third-party compliance review. For a detailed cost breakdown, see our AI governance consulting cost page.
We applied this audit logging pattern for an enterprise software company deploying a knowledge management bot on Copilot Studio and Azure AI Foundry:
Enterprise software company
Accurate, prompt responses for both document-specific queries and broader general knowledge questions from a unified AI assistant
Conversation transcript records in Dataverse include the topic execution flow, which shows plugin invocation nodes. However, the inputs and outputs of those plugin or Power Automate calls are not captured in the transcript record by default. You need to instrument each connected flow to log its own inputs and outputs to a Dataverse table or Application Insights custom event separately.
Share your requirements with QServices. Our engineers will give you a straight answer on fit, timeline, and cost — no sales scripts.
Book a Free Consultation