Unable to Find "Audit"/"Auditing" Table in Synapse Link for Dataverse Audit Export

Question

Unable to Find "Audit"/"Auditing" Table in Synapse Link for Dataverse Audit Export

Duc Tran Minh 15

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!

TDCG 0 Reputation points

2025-06-18T18:25:18.5133333+00:00

I'm experiencing this exact same issue. Microsoft's documentation clearly states "Under the list of tables, select the Auditing and User tables."

However, just below that, it also notes "The tables you select must have change tracking enabled". It’s unclear whether this means the table won’t sync to the Synapse workspace without change tracking enabled, or if the table simply won’t appear in the list of selectable tables.

If it's the latter, then the Auditing table would require change tracking to be enabled—but so far, I haven't been able to enable it successfully.

I've confirmed that Azure Data Lake Storage is in the same region as the Dataverse environment. Article's like this one (see screenshot below) also suggest that it is possible:
Dmitriy Andreyanov 0 Reputation points

2025-07-08T11:26:02.7433333+00:00

Hi Daniel, I have the same problem. Were you able to add the audit table to Synapse Link?
Chris Jameson 0 Reputation points

2025-07-14T01:41:13.59+00:00
Add "/api/data/v9.1/EntityDefinitions(LogicalName=%27audit%27)?$select=DisplayName,MetadataId,ChangeTrackingEnabled"

to the end of your Environment. Change your region crm#

Eg https://myenvname.crm6.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName=%27audit%27)?$select=DisplayName,MetadataId,ChangeTrackingEnabled

If you get Disabled like the below log a ticket with support to run required backend scripts to Enable

The env should return

Change Tracking Enabled -

"ChangeTrackingEnabled":true

Change Tracking Disabled

"ChangeTrackingEnabled":false

1 answer

Your answer

TDCG 0 Reputation points

2025-06-18T18:25:18.5133333+00:00

I'm experiencing this exact same issue. Microsoft's documentation clearly states "Under the list of tables, select the Auditing and User tables."

However, just below that, it also notes "The tables you select must have change tracking enabled". It’s unclear whether this means the table won’t sync to the Synapse workspace without change tracking enabled, or if the table simply won’t appear in the list of selectable tables.

If it's the latter, then the Auditing table would require change tracking to be enabled—but so far, I haven't been able to enable it successfully.

I've confirmed that Azure Data Lake Storage is in the same region as the Dataverse environment. Article's like this one (see screenshot below) also suggest that it is possible:
Dmitriy Andreyanov 0 Reputation points

2025-07-08T11:26:02.7433333+00:00

Hi Daniel, I have the same problem. Were you able to add the audit table to Synapse Link?
Chris Jameson 0 Reputation points

2025-07-14T01:41:13.59+00:00

Add "/api/data/v9.1/EntityDefinitions(LogicalName=%27audit%27)?$select=DisplayName,MetadataId,ChangeTrackingEnabled"

to the end of your Environment. Change your region crm#

Eg https://myenvname.crm6.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName=%27audit%27)?$select=DisplayName,MetadataId,ChangeTrackingEnabled

If you get Disabled like the below log a ticket with support to run required backend scripts to Enable

The env should return

Change Tracking Enabled -

"ChangeTrackingEnabled":true

Change Tracking Disabled

"ChangeTrackingEnabled":false

Answer 1

simo-k 69,055 Volunteer Moderator

Microsoft Q&A(en-us) does not support Power Platform.
For questions about Power Platform (PowerApps, PowerAutomate, etc.), please ask in the official dedicated community below.
Power Platform Community
　├ Copilot Studio
　├ Power Apps
　├ Power Automate
　│　└ Power Automate Desktop
　└ Power Pages

Share via

Unable to Find "Audit"/"Auditing" Table in Synapse Link for Dataverse Audit Export

1 answer

Your answer