Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to export Dynamic ...
Customer experience | Sales, Customer Insights,...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by BM-02050622-0 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans