Written by Customers who use Azure Synapse Link for Dataverse can export audit logs easily to meet the external and internal auditing, compliance, security, and governance policies that are common to many enterprises.
Microsoft Dataverse auditing is supported on all custom and most customizable tables and columns. Audit logs are stored in Dataverse and consume log storage capacity. If you have Azure resources in the same region as the Dataverse environment, you can export audit logs to an Azure storage account using Azure Synapse Link for Dataverse and query the audit logs using Azure Synapse Analytics and Power BI Desktop.
Prerequisites
- An Azure subscription with admin permissions to create resource groups, workspace, and other Azure assets. More information: Create an Azure Synapse Link for Dataverse with your Azure Synapse Workspace
- You must have the Dataverse system administrator security role.
- Power BI.
Tasks to complete
Here are the high-level steps for creating the storage and workspace in Azure, then the Azure Synapse Link for Dataverse so you can create reports in Power BI:
- Create an Azure Synapse Link
- Create a resource group.
- Create an Azure Data Lake Storage Gen2 account with hierarchical directory enabled.
- Create a Synapse workspace.
- Create an Apache Spark pool for the Synapse workspace.
- To enable your app maker the ability to create an Azure Synapse Link for Dataverse, grant storage account and synapse workspace permissions to the Power Platform maker.
- Connect Dataverse audit table to Synapse workspace
- Verify the auditing table’s sync status.
- Create reports and dashboards using Power BI
Read full post here: Access audit data with Azure Synapse Link and Power BI – Power Platform | Microsoft Learn
Dynatecon Solutions 