Skip to main content

Notifications

Announcements

Forum Structure Changes on 11/8 – Update Your Subscriptions!
News and Announcements icon
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

Forum Structure Changes on 11/8 – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans