To internally develop a monitoring solution based on the audit log data, a PowerShell script which searches and exports the audit log data to a CSV file can be scheduled. This CSV file is then used as the source of an extract-transform-load (ETL) or extract-load-transform (ELT) process to persist the log data in a source system, such as a SQL Server database. Finally, Power BI Desktop can be used to implement remaining lightweight transformations, create DAX measures, and develop the monitoring reports.
The following list of steps and supporting screenshots describe the monitoring workflow in detail:
- A PowerShell script (.ps1) is executed on a schedule and generates a CSV file of Power BI activities:
The ...
