SQL Database Auditing content pack for Power BI
The Power BI content pack for Azure SQL Database Auditing allows you to understand your database activity and gain insight into discrepancies and anomalies that could indicate business concerns or suspected security violations.
Connect to the SQL Database Auditing content pack for Power BI.
The content pack imports data from all tables that contain “AuditLogs” in their name and append it to a single data model table named “AuditLogs”. The last 250k events will be included and the data will be refreshed daily.
How to connect
Select Get Data at the bottom of the left navigation pane.
In the Services box, select Get.
Select SQL Database Auditing > Get.
In the Connect to Sql Database Auditing window:
Enter the Azure Table Storage account name or URL where your logs are stored.
Enter the name of the SQL server that you are interested in. Enter “*” to load audit logs for all servers.
Enter the name of the SQL database that you are interested in. Enter “*” to load audit logs for all databases.
Enter the name of the Azure table that contains the logs you are interested. Enter “*” to load audit logs from all tables that contain “AuditLogs” in their name.
For performance reasons it is advisable to always specify an explicit table name even if all audit logs are stored in a single table.
Enter the start date of audit logs you are interested in. Enter “*” to load audit logs without a lower time limit, or “1d” to load audit logs from the last day.
Enter the end date of audit logs you are interested in. Enter “*” to load audit logs without an upper time limit.
For Authentication Method, select Key, enter your Account Key > Sign In.
After Power BI imports the data, you see a new dashboard, report, and dataset in the left navigation pane. New items are marked with a yellow asterisk *.
- Try asking a question in the Q&A box at the top of the dashboard
- Change the tiles in the dashboard.
- Select a tile to open the underlying report.
- While your dataset will be schedule to refreshed daily, you can change the refresh schedule or try refreshing it on demand using Refresh Now