Power Platform Community Forum Thread Details

Hi,

I’m following the Microsoft documentation here:
https://learn.microsoft.com/en-us/power-platform/admin/audit-data-azure-synapse-link

In the section “Connect Dataverse audit table to Synapse workspace”, the guide mentions an "Auditing" or "Audit" table. However, when I try to set up the Synapse Link, I’m unable to locate any table with that name in the available table list.

Here’s what I’ve already configured:

Enabled environment auditing via the Power Platform admin center.
Enabled table-level auditing by checking "Audit changes to its data" under the advanced options for all relevant tables in Power Apps.

My goal is to export Power Platform audit logs to a Storage Account and, if possible, forward that data into an Azure Log Analytics workspace for further analysis.

Could you clarify:

Is there an expected delay before the audit table appears in Synapse Link?
Is there any additional configuration needed to make the audit data exportable via Synapse?
If Synapse cannot be used for this purpose, is there a supported alternative to stream audit logs to Log Analytics?

Thanks in advance for your help!

Categories:

Microsoft Dataverse with Power Apps

@CU10060722-0

Thanks for your detailed explanation—you're definitely on the right track. Based on the latest Microsoft documentation and community discussions, here are some key clarifications regarding your issue:

1. Audit Table Visibility in Synapse Link

The "Audit" or "Auditing" table may not appear in the Synapse Link table list unless certain conditions are met:

Change Tracking Requirement: The audit table must have change tracking enabled to be eligible for export via Synapse Link. However, unlike standard tables, the audit table doesn't expose this setting in the usual UI, and enabling it might not be straightforward or even possible via the Power Apps interface.
Delay in Availability: There might be a delay (sometimes several hours) after enabling auditing before the table becomes visible in the Synapse Link configuration. This delay can depend on backend processing and synchronization.

2. Additional Configuration

Ensure that Azure Data Lake Storage Gen2 is in the same region as your Dataverse environment.
Confirm that the Power Platform admin has the necessary Storage Blob Data Contributor and Synapse Contributor roles on the storage account and Synapse workspace
2
.
If the audit table still doesn’t appear, it may be due to backend limitations or missing internal flags that Microsoft hasn’t fully documented.

3. Alternative to Synapse for Audit Logs

If Synapse Link doesn’t work for your audit export needs, consider this supported alternative:

Microsoft Purview Audit (formerly Microsoft 365 Compliance Center):
- Power Platform audit logs can be accessed via Microsoft Purview if your tenant is configured for unified auditing.
- These logs can be streamed to Azure Monitor / Log Analytics using Microsoft Sentinel or custom ingestion pipelines.
Power Platform Admin API:
- You can use the Power Platform Admin connectors or Dataverse Web API to extract audit data programmatically and push it to Log Analytics.