适用于 Power BI 的 SQL 数据库审核内容包SQL Database Auditing content pack for Power BI

通过适用于 Azure SQL 数据库审核的 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.

连接到适用于 Power BI 的 SQL 数据库审核内容包Connect to the SQL Database Auditing content pack for Power BI.

备注

此内容包从名称包含“AuditLogs”的所有表中导入数据,并将其附加到名为“AuditLogs”的单个数据模型表中。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”. 会包含最近 250k 事件,并且每天刷新数据。The last 250k events will be included and the data will be refreshed daily.

如何连接How to connect

  1. 选择左侧导航窗格底部的获取数据Select Get Data at the bottom of the left navigation pane.

  2. 在“服务”框中,选择“获取”。In the Services box, select Get.

  3. 选择 SQL 数据库审核>获取Select SQL Database Auditing > Get.

  4. 在“连接到 Sql Database 审核”窗口中:In the Connect to Sql Database Auditing window:

    • 输入在其中存储日志的 Azure 表存储帐户名称或 URL。Enter the Azure Table Storage account name or URL where your logs are stored.

    • 输入你感兴趣的 SQL Server 的名称。Enter the name of the SQL server that you are interested in. 输入“*”可加载所有服务器的审核日志。Enter “*” to load audit logs for all servers.

    • 输入你感兴趣的 SQL 数据库的名称。Enter the name of the SQL database that you are interested in. 输入“*”可加载所有数据库的审核日志。Enter “*” to load audit logs for all databases.

    • 输入包含你感兴趣的日志的 Azure 表的名称。Enter the name of the Azure table that contains the logs you are interested. 输入“*”可从名称中包含“AuditLogs”的所有表加载审核日志。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. 输入“*”可加载没有时间下限的审核日志,输入“1d”可从最近一天加载审核日志。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.

  5. 对于“身份验证方法”,请选择“密钥”,输入你的帐户密钥>,然后选择“登录”。For Authentication Method, select Key, enter your** Account Key** > Sign In.

  6. Power BI 导入数据后,你会在左侧的导航窗格中看到新的仪表板、报表和数据集。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 *.

下一步?What now?

后续步骤Next steps

获取 Power BI 数据 获取 Power BI 数据Get data for Power BI Get started with Power BI