Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

How to export Dynamic 365 Audit logs to Azure Data Lake Gen2?

Posted on by 2

We want to free some space from dynamics 365, also want to create some reports on audit data.

We are already doing similar things with other entities with synapse link but audit not available in synapse link.

we need solution to move old audit data to azure data lake storage gen2.

  • Suggested answer
    Cui Hao Profile Picture
    Cui Hao on at
    How to export Dynamic 365 Audit logs to Azure Data Lake Gen2?
    Hi,
     
    According to this official document, the audit table can't be enabled for change tracking.
    Use change tracking to synchronize data with external systems (Microsoft Dataverse) - Power Apps | Microsoft Learn
     
    Best regards,
    Cui Hao

  • BM-02050622-0 Profile Picture
    BM-02050622-0 2 on at
    How to export Dynamic 365 Audit logs to Azure Data Lake Gen2?
    Hi,
       I followed the same document to create azure synapse link but the Auditing table is not showing in the azure synapse table list. Only the tables which has ChangeTrack property enabled will shown in the list but this property is disabled for audit table. How could enable I enable this property for audit table since this entity is not showing in powerapps?
  • Suggested answer
    Cui Hao Profile Picture
    Cui Hao on at
    How to export Dynamic 365 Audit logs to Azure Data Lake Gen2?
    Hi,

    You may refer to the following link:
    Access audit data with Azure Synapse Link and Power BI - Power Platform | Microsoft Learn
    You can follow the link above. This link describes how to create an Azure Synapse link and how to go about connecting a Dataverse audit table to a Synapse workspace.


    Best regards,
    Hugh Cui

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,632 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,528 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans