適用於 Power BI 的 SQL Database 稽核內容套件SQL Database Auditing content pack for Power BI

Power BI 的 Azure SQL Database 稽核內容套件可協助您了解資料庫活動,以及獲取可能指出業務疑慮或可疑安全性違規之差異及異常的深入資訊。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 Database 稽核內容套件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 Database 稽核] > [取得]。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 BIGet data for Power BI Get started with Power BI