Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
colonel_claypoo
Frequent Visitor

Automated Purview audit log reports?

I don't have much Power BI experience but wanted to know if it's possible to create reports from the Purview audit log data?
I know the manual and PowerShell way to get the data from Purview into Power BI. However, I'm looking for an automated, ideally unattended solution. I've read about the Office 365 Management Activity API and I'm thinking it might be an option if there was a way to connect this to a Power BI dataset/report. I appreciate your ideas.

1 ACCEPTED SOLUTION
nilendraFabric
Super User
Super User

Hello @colonel_claypoo 

 

there are many methods to do this including the one you mentioned using O365 management api

 

Office 365 Management Activity API :


The Office 365 Management Activity API provides programmatic access to audit log data and can be used to create automated, unattended solutions. To use this method:
• Register an application in Azure AD and configure appropriate permissions
• Use the API to retrieve audit log data programmatically
• Connect the API to Power BI using Power Query or custom connectors

 

 

azure event hub

 

Microsoft Purview can be configured to stream audit logs to Azure Event Hubs. From there, you can:
• Capture the streaming data in Azure Storage
• Use Azure Data Factory or other ETL tools to process the data
• Load the processed data into Power BI for reporting

 

Power Automate (Flow) Integration
You can create a Power Automate flow to:
• Periodically retrieve audit log data using the Office 365 Management Activity API
• Process and filter the data as needed
• Write the data to a SharePoint list or other data source
• Connect the data source to Power BI for reporting

Even Azure log analytics will solve this as well

 

Please accept the solution and give kudos if this is helpful 

 

 

View solution in original post

4 REPLIES 4
Dean_Gross
New Member

nilendraFabric
Super User
Super User

Hello @colonel_claypoo 

 

there are many methods to do this including the one you mentioned using O365 management api

 

Office 365 Management Activity API :


The Office 365 Management Activity API provides programmatic access to audit log data and can be used to create automated, unattended solutions. To use this method:
• Register an application in Azure AD and configure appropriate permissions
• Use the API to retrieve audit log data programmatically
• Connect the API to Power BI using Power Query or custom connectors

 

 

azure event hub

 

Microsoft Purview can be configured to stream audit logs to Azure Event Hubs. From there, you can:
• Capture the streaming data in Azure Storage
• Use Azure Data Factory or other ETL tools to process the data
• Load the processed data into Power BI for reporting

 

Power Automate (Flow) Integration
You can create a Power Automate flow to:
• Periodically retrieve audit log data using the Office 365 Management Activity API
• Process and filter the data as needed
• Write the data to a SharePoint list or other data source
• Connect the data source to Power BI for reporting

Even Azure log analytics will solve this as well

 

Please accept the solution and give kudos if this is helpful 

 

 

I think Azure Event Hub would incur additional costs but might be the easiest route to set up. Hadn't though about Power Automate in combination with the Management API. Will look further into both. Thanks.

Hi @colonel_claypoo , thank you for reaching out to the Microsoft Fabric Community Forum.

 

Just wanted to confirm if your issue is been solved. If it is, please mark it 'Accept as Solution'. If not, then please share the details for us to work together to solve it.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.