在 Power BI Desktop 中連線到 Azure 使用量見解資料Connect to Azure Consumption Insights data in Power BI Desktop

• 10/14/2019
• • d
  • o

您可以使用 Power BI Desktop 連線至 Azure，並取得有關貴組織 Azure 服務使用量的深入資料。You can use Power BI desktop to connect to Azure and get in-depth data about your organization's Azure service usage. 有了此資料，您就可以建立自訂報表與量值，以便更充分了解並分析您的 Azure 費用。With this data, you can create custom reports and measures to better understand and analyze your Azure spend.

與 Azure 使用量見解進行連線Connect with Azure Consumption Insights

Azure 使用量見解可讓您連線至 Azure Enterprise 合約的帳單帳戶。Azure Consumption Insights allows you to connect to Azure Enterprise Agreement billing accounts.

在本節中，您會了解如何使用 Azure 企業版連接器取得您需要遷移的資料。In this section, you learn how to get the data you need migrate using the Azure Enterprise Connector. 您也可以在 ACI (Azure 使用量見解) API 中找到可用的「使用量詳細資料資料行」對應。You'll also find a usage details columns mapping available in the ACI (Azure Consumption Insights) API.

若要成功使用 Azure 使用量見解 連接器，您需要存取 Azure 入口網站企業版的功能。To successfully use the Azure Consumption Insights connector, you need access to the Azure portal Enterprise features.

在 Power BI Desktop 中使用 Azure 使用量見解 連接器：To use the Azure Consumption Insights connector in Power BI Desktop:

1. 從 [常用] 功能區選取 [取得資料]。From the Home ribbon, select Get Data.

2. 從左側的類別中選取 [線上服務]。From the categories on the left, select Online Services.

3. 選取 [Microsoft Azure 使用量見解 (搶鮮版 (Beta))]。Select Microsoft Azure Consumption Insights (Beta).

4. 選取 [連接]。Select Connect.

   

   在出現的對話方塊中，輸入您的 Azure 註冊號碼。In the dialog that appears, enter your Azure Enrollment Number.

   

   • 您可以從 Azure 企業版入口網站取得註冊號碼，位置如下圖所示：You can get your enrollment number from the Azure Enterprise Portal, in the location shown in the following image:

此連接器版本只支援來自 https://ea.azure.com 的 Enterprise 註冊。This connector version only supports enterprise enrollments from https://ea.azure.com. 中國目前不支援註冊。China enrollments aren't currently supported.

接下來，提供連接用的「存取金鑰」。Next, provide your Access key to connect.

• 您的註冊用存取金鑰可以在 Azure 企業版入口網站找到。Your Access key for enrollment can be found on the Azure Enterprise Portal.

在您提供「存取金鑰」並選取 [連線] 後，隨即會出現一個 [導覽器] 視窗，顯示九個可用的資料表：Once you provide your Access key and select Connect, a Navigator window appears and shows nine available tables:

您可以選取任何資料表旁邊的核取方塊，以便查看預覽。You can select a checkbox beside any table to see a preview. 您可以藉由核取名稱旁邊的方塊，選取一或多個資料表，然後選擇 [載入]。You can select one or more tables by checking the box beside their name, then select Load.

當您選取 [載入] 時，資料會載入 Power BI Desktop。When you select Load, the data is loaded into Power BI Desktop.

您選取的資料載入後，可以在 [欄位] 窗格看到您所選取的資料表和欄位。Once the data you selected is loaded, the tables and fields you selected can be seen in the Fields pane.

使用 Azure 使用深入解析Using Azure Consumption Insights

若要使用 Azure 使用量見解 連接器，您可以存取 Azure 入口網站企業版的功能。To use the Azure Consumption Insights connector, you access to the Azure portal Enterprise features.

使用 Azure 使用量見解 連接器成功載入資料後，您可以使用 [查詢編輯器] 建立您自己的自訂量值和資料行。Once you successfully load data using the Azure Consumption Insights connector, you can create your own custom measures and columns using Query Editor. 您也可以建立視覺效果、報表和儀表板，以在 Power BI 服務 中共用。You can also create visuals, reports, and dashboards for sharing in the Power BI service.

使用空白查詢，您可以擷取範例 Azure 自訂查詢集合。With a blank query, you can retrieve a sample Azure custom queries collection. 您可以透過兩種方式進行此種擷取：There are two ways you can do this retrieval:

在 Power BI Desktop 中：In Power BI Desktop:

1. 選取 [常用] 功能區Select the Home ribbon
2. 選取 [取得資料] > [空白查詢]Select Get Data > Blank Query

或者，在 [查詢編輯器] 中：Or, in Query Editor:

1. 在左側的 [查詢] 窗格中以滑鼠右鍵按一下Right-click in the left Queries pane
2. 在出現的功能表中選取 [新查詢] > [空白查詢]Select New Query > Blank Query from the menu that appears

在 [公式列] 中，鍵入： = MicrosoftAzureConsumptionInsights.Contents。In the Formula bar, type: = MicrosoftAzureConsumptionInsights.Contents.

下圖顯示隨即出現的範例集合。The following image shows a samples collection that appears.

使用報表和建立查詢時，您可以：When working with reports and creating queries, you can:

• 若要定義從目前日期開始的月份數，請使用 numberOfMonthTo define the number of months starting from the current date, use numberOfMonth
  • 使用介於一到 36 之間的值。Use a value between one and 36. 代表您要匯入的月份數 (從目前的日期開始)。Represent the number of months, from the current date, you want to import. 我們建議您不要取得超過 12 個月份的資料。We recommend getting no more than 12 months of data. 這項限制可以避免到達 Power BI 查詢匯入條件約束和資料量閾值。This limit avoids Power BI query import constraints and data volume thresholds.
• 若要定義歷程記錄時間範圍中的月份期間，請使用 startBillingDataWindow 和 endBillingDataWindowTo define a period of months in a historical time window, use startBillingDataWindow and endBillingDataWindow
• 請不要與 startBillingDataWindow 或 endBillingDataWindow 一同搭配使用 numberOfMonthDon't use numberOfMonth together with startBillingDataWindow or endBillingDataWindow

從 Azure 企業版連接器遷移Migrate from the Azure Enterprise Connector

有些客戶已使用「Azure 企業版連接器 (搶鮮版 (Beta))」來建立視覺效果。Some customers created visuals using the Azure Enterprise Connector (Beta). 該連接器最終會由 Azure 使用量見解 連接器取代。Eventually, it will be replaced with the Azure Consumption Insights connector. 新的連接器具備的功能和加強功能包括：The new connector has features and enhancements that include:

• 適用於 Balance Summary 和 Marketplace Purchases 的其他資料來源Additional data sources available for Balance Summary and Marketplace Purchases
• 新參數和進階參數，例如 startBillingDataWindow 和 endBillingDataWindowNew and advanced parameters, such as startBillingDataWindow and endBillingDataWindow
• 較佳的效能和回應Better performance and responsiveness

接下來的步驟會示範如何轉換到 Azure 使用量見解 連接器。The next steps show how to transition to the Azure Consumption Insights connector. 這些步驟可以保留您在建立自訂儀表板或報表時已完成的工作。These steps preserve the work you've already done in creating custom dashboards or reports.

步驟 1：使用新的連接器連線到 AzureStep 1: Connect to Azure using the new connector

第一個步驟是使用本文稍早所詳述的 Azure 使用量見解。The first step is use the Azure Consumption Insights connector described in detail earlier in this article. 在此步驟中，從 Power BI Desktop 的 [首頁] 功能區選取 [取得資料] > [空的查詢] 。In this step, select Get Data > Blank Query from the Home ribbon in Power BI Desktop.

步驟 2：在進階查詢器中建立查詢Step 2: Create a query in Advanced Editor

在 [查詢編輯器] 中，從 [常用] 功能區的 [查詢] 區段選取 [進階編輯器]。In Query Editor, select Advanced Editor from the Home ribbon's Query section. 在出現的 [進階編輯器] 視窗中，輸入此查詢：In the Advanced Editor window that appears, enter this query:

let    
    enrollmentNumber = "100",
    optionalParameters = [ numberOfMonth = 6, dataType="DetailCharges" ],
    data = MicrosoftAzureConsumptionInsights.Contents(enrollmentNumber, optionalParameters)   
in     
    data

您需要將 enrollmentNumber 值替換成您的註冊號碼。You'll need to replace the enrollmentNumber value with your enrollment number. 您可以從 Azure 企業版入口網站取得您的號碼。You can get your number from the Azure Enterprise Portal. numberOfMonth 參數是您要傳回幾個月的資料，從目前的日期起算。The numberOfMonth parameter is how many months of data you want going back, from the current dat. 使用零 (0) 代表目前的月份。Use zero (0) for the current month.

在 [進階編輯器] 視窗中選取 [完成] 之後，預覽會重新整理，且資料表中會出現指定月份範圍的資料。Once you select Done in the Advanced Editor window, the preview refreshes and data from the specified month range appears in the table. 選取 [關閉並套用] 然後返回。Select Close & Apply and return.

步驟 3：將量值和自訂資料行移至新的報表Step 3: Move measures and custom columns to the new report

接下來，您必須將任何自訂資料行或您所建立量值移至新的詳細資料資料表。Next, you'll need to move any custom columns or measures you created into the new details table. 以下是步驟。Here are the steps.

1. 開啟 [記事本] (或其他文字編輯器)。Open Notepad (or another text editor).

2. 選取您想要移動的量值，並從 [公式] 欄位複製文字且放在 [記事本] 中。Select the measure you want to move, copy the text from the Formula field, and place it in Notepad.

   

3. 將 Query1 重新命名為原始的詳細資料資料表名稱。Rename Query1 to the original details table name.

4. 若要建立新的資料表量值和自訂資料行，請以滑鼠右鍵按一下資料表，然後選擇 [新量值]。To create new table measures and custom columns, right-click on your table, and choose New Measure. 然後，請剪下並貼上您儲存的量值和資料行，直到全部完成為止。Then, cut and paste your stored measures and columns until they're all done.

步驟 4：重新連結具有關聯性的資料表Step 4: Relink tables that had relationships

許多儀表板有其他用來查閱或篩選的資料表，例如日期資料表或用於自訂專案的資料表。Many dashboards have additional tables that are used for lookup or filtering, such as date tables or tables used for custom projects. 重新建立這些關聯性，可以解決大部分剩餘的問題。Reestablishing those relationships resolves most remaining issues. 以下說明如何執行這項作業。Here's how to do it.

• 在 Power BI Desktop 的 [模型] 索引標籤中，選取 [管理關聯性]，以顯示視窗讓您管理模型內的關聯性。In the Modeling tab in Power BI Desktop, select Manage Relationships to bring up a window that lets you manage relationships within the model. 視需要重新連結您的資料表。Relink your tables, as needed.

  

步驟 5：驗證視覺效果，然後視需要調整欄位格式設定Step 5: Verify your visuals, and adjust field formatting as needed

此時，大部分的原始視覺效果、資料表和向下切入動作都應該如預期般運作。At this point, most of your original visuals, tables, and drill-down actions should be working as expected. 但是您可能需要進行一些小幅度的調校，來精確地設定外觀及操作的格式。Some minor tweaks may be necessary, however, to precisely format the look and feel. 請花費一些時間查看每個儀表板和視覺效果，確保它們看起來與您想要的外觀一致。Take a bit of time to look over each of your dashboards and visuals to ensure they look how you want them.

使用 Azure 使用深入解析 (ACI) API 來取得使用資料Using the Azure Consumption and Insights (ACI) API to get consumption data

Azure 也提供 Azure 使用深入解析 (ACI) API。Azure also provides the Azure Consumption and Insights (ACI) API. 您可以建立自己的自訂解決方案，來使用 ACI API 收集、報告和視覺化 Azure 使用資訊。You can create your own custom solutions to gathering, reporting, and visualizing Azure consumption information using the ACI API.

在入口網站、連接器和 API 之間對應名稱和使用詳細資料Mapping names and usage details between the portal, the connector, and the API

Azure 入口網站資料行和詳細資料名稱在 API 和連接器中非常相似，雖然並非完全相同。The Azure portal columns and details names are similar in the API and the connector, though not always identical. 為了協助您進行釐清，下表提供對應。To help clarify, the following table provides a mapping. 同時也指出資料行是否已經淘汰。Also indicated is whether the column is obsolete. 如需詳細資訊和字詞定義，請參閱 Azure 計費資料字典。For more information, and term definitions, see the Azure billing data dictionary.

後續步驟Next steps

您可以使用 Power BI Desktop 連線到許多不同的資料來源。You can connect to many different data sources using Power BI Desktop. 如需詳細資訊，請參閱下列文章：For more information, see the following articles:

• 在 Power BI Desktop 中連線到 Azure 成本管理資料Connect to Azure cost management data in Power BI desktop
• Power BI Desktop 是什麼？What is Power BI Desktop?
• Power BI Desktop 中的資料來源Data Sources in Power BI Desktop
• 使用 Power BI Desktop 合併資料並使其成形Shape and Combine Data with Power BI Desktop
• 在 Power BI Desktop 中連接至 Excel 活頁簿Connect to Excel workbooks in Power BI Desktop
• 直接將資料輸入 Power BI Desktop 中Enter data directly into Power BI Desktop