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.
Note: 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.
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.
Important: 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 *.