在 Microsoft 365 使用方式分析中自訂報告Customize the reports in Microsoft 365 usage analytics


系統管理中心正在變更。The admin center is changing. 如果您的體驗不符合此處所示的詳細資料,請參閱 關於新版 Microsoft 365 系統管理中心 (英文)。If your experience doesn't match the details presented here, see About the new Microsoft 365 admin center.

Microsoft 365 流量分析提供 Power BI 中的儀表板,可深入瞭解使用者採用和使用 Microsoft 365 的方式。Microsoft 365 usage analytics provides a dashboard in Power BI that offers insights into how users adopt and use Microsoft 365. 儀表板只是與使用狀況資料互動的起點。The dashboard is just a starting point to interact with the usage data. 您可以自訂報告,以獲得更多個人化洞察力。The reports can be customized for more personalized insights.

您也可以使用 Power BI 桌面來進一步自訂報告,方法是將其連線至其他資料來源,以深入瞭解您的企業。You can also use the Power BI desktop to further customize your reports by connecting them to other data sources to gain richer insights about your business.

在瀏覽器中自訂報告Customizing reports in the browser

下列兩個範例示範如何修改現有的視覺效果,以及如何建立新的視覺效果。The following two examples show how to modify an existing visual and how to create a new visual.

修改現有的視覺效果Modify an existing visual

此範例顯示如何在 啟用/授權 報告中修改 [啟用] 索引標籤。This example shows how to modify the Activation tab within the Activation/Licensing report.

  1. 在 [ 啟用/授權 ] 報告中,選取 [ 啟用 ] 索引標籤。Within the Activation/Licensing report, select the Activation tab.

  2. 在 [Power BI] 的 [其他頁面] 按鈕中,選擇上方的 [ 編輯 ] 按鈕,以進入編輯模式  Enter the edit mode by choosing the Edit button on the top through the The more page button in Power BI button.

    按一下右上方導覽中的 [編輯報告]

  3. 在右上方,選擇 [ 複製此頁面]。On the top right, choose Duplicate this page.

    選擇 [複製此頁面]

  4. 在右下方,選擇顯示根據 OS (如 Android、iOS、Mac 等)啟動之使用者計數的任何橫條圖。In the bottom right, choose any of the bar-charts showing the count of users activating based on the OS such as Android, iOS, Mac, etc.

  5. 在右側的 視覺化 區域中,若要從視覺中移除 Mac 計數 ,請選取它旁邊的 XIn the Visualizations area to the right, in order to remove Mac Count from the visual, select the X next to it.

    移除 Mac 計數

建立新的視覺Create a new visual

下列範例顯示如何建立新的視覺效果,以每月追蹤新的 Yammer 使用者。The following example shows how to create a new visual to track new Yammer users on monthly basis.

  1. 使用左導覽移至 [ 產品使用狀況 ] 報告,然後選取 [ Yammer ] 索引標籤。Go to the Product Usage report using the left nav and select the Yammer tab.

  2. 選擇  [POWER BI] 和 [編輯] 中的 [更多頁面] 按鈕,切換至編輯模式 ****。Switch to edit mode by choosing The more page button in Power BI and Edit.

  3. 在頁面底部,選取At the bottom of the page, select the Power BI 中的 [新增頁面] 按鈕 以建立新的頁面。to create a new page.

  4. 在右側的 視覺化 區域中,選擇 [ 堆疊橫條圖 ] (頂端列(從左) 開始)。In the Visualizations area to the right, choose the Stacked bar chart (top row, first from left).


  5. 選取該視覺化效果的右下方,並拖曳以放大顯示。Select the bottom right of that visualization and drag to make it larger.

  6. 在右側的 [ 欄位 ] 區域中,展開 [行事 ] 表格。In the Fields area to the right, expand the Calendar table.

  7. MonthName 拖曳至 [欄位] 區域,其位於 視覺化 區域的 [座標軸] 標題下方。Drag MonthName to the fields area, directly below the Axis heading in the Visualizations area.


  8. 在右側的 [ 欄位 ] 區域中,展開 [ TenantProductUsage ] 表格。In the Fields area to the right, expand the TenantProductUsage table.

  9. FirstTimeUsers 拖曳至 [欄位] 區域,直接在 標題下方。Drag FirstTimeUsers to the fields area, directly below the Value heading.

  10. 產品 拖曳至 [ 篩選 ] 區域,直接在 [ 視覺層級篩選 ] 標題下。Drag Product to the Filters area, directly below the Visual level filters heading.

  11. 在出現的 [ 篩選類型 ] 區域中,選取 [ Yammer ] 核取方塊。In the Filter Type area that appears, select the Yammer check box.

    選取 Yammer 核取方塊

  12. 在視覺效果的清單下方,選擇 ![ Power BI Visualizaions] 中的格式圖示格式圖示 Just below the list of visualizations, choose the Format icon Format icon in Power BI Visualizaions.

  13. 按月,展開 [標題],然後將 [ 標題] 文字 值變更為 [ 第一次 Yammer] 使用者Expand Title and change the Title Text value to First-Time Yammer Users by Month.

  14. 文字大小 值變更為 12Change the Text Size value to 12.

  15. 在右下方編輯頁面名稱,以變更新頁面的標題。Change the title of the new page by editing the name of the page on bottom right.

  16. 按一下頂端的 [ 閱讀檢視 ],然後按一下 [ 儲存] 來儲存報告。Save out the report by Clicking on Reading View on top and then Save.

自訂 Power BI Desktop 中的報表Customizing the reports in Power BI Desktop

大多數客戶在 Power BI web 中修改報告和圖表視覺效果的情況都會夠用。For most customers modifying the reports and chart visuals in Power BI web will be sufficient. 在某些情況下,您可能需要將此資料與其他資料來源結合,以獲得更深入的業務相關內容,在這種情況下,他們可以使用 Power BI Desktop 自訂及建立其他報告。For some however, there may be a need to join this data with other data sources to gain richer insights contextual to their own business, in which case they can customize and build additional reports using Power BI Desktop. 您可以免費下載 POWER BI desktopYou can download Power BI Desktop for free.

使用報表 APIsUse the reporting APIs

您可以開始直接連線至 Microsoft 365 的 ODATA 報告 APIs,以加上這些報告。You can start by connecting directly to the ODATA reporting APIs from Microsoft 365 that power these reports.

  1. 移至 [ 取得資料 > ] 其他 > ODATA 摘要 > ConnectGo to get data > Other > ODATA Feed > Connect.

  2. 在 [URL] 視窗中,輸入 "HTTPs:// reports.office.com/pbi/v1.0/ <tenantid> "In the URL window enter "https://reports.office.com/pbi/v1.0/<tenantid>"

    附注: 報告 APIs 是在預覽中,且在實際執行之前必須變更。NOTE: The reporting APIs are in preview and are subject to change until they go into production.

    OData Power BI desktop 的摘要 URL

  3. 當系統提示時,請輸入您的 Microsoft 365 (組織或學校) 系統管理員認證,以向 Microsoft 365 驗證。Enter your Microsoft 365 (organization or school) admin credentials to authenticate to Microsoft 365 when prompted.

    如需允許存取 Microsoft 365 採用範本應用程式報告之使用者的詳細資訊,請參閱 FAQSee the FAQ for more information about who is allowed to access the Microsoft 365 Adoption template app reports.

  4. 連線授權後,您將會看到 [Navigator] 視窗,顯示可供連線的資料集。Once the connection is authorized, you will see the Navigator window that shows the datasets available to connect to.

    選取 [全部],然後選擇 [ 負載]。Select all and choose Load.

    這會將資料下載到您的 Power BI Desktop。This will download the data into your Power BI Desktop. 儲存此檔案,然後您就可以開始建立所需的報告。Save this file and then you can start creating the reports you need.

    報告 API 中可用的 ODATA 值

使用 Microsoft 365 流量分析範本Use the Microsoft 365 usage analytics template

您也可以使用與 Microsoft 365 使用方式分析報告對應的 Power BI 範本檔案,作為連接至資料的起點。You can also use the Power BI template file that corresponds to the Microsoft 365 usage analytics reports as a starting point to connect to the data. 使用 pbit 檔案的優點是已建立連接字串。The advantage of using the pbit file is that it has the connection string already established. 您也可以利用基礎架構傳回的資料與基礎架構傳回的所有自訂量值,並進一步加以建立。You can also take advantage of all the custom measures that are created, on top of the data that the base schema returns and build on it further.

您可以從 下載中心從 Microsoft 下載中心下載 Power BI 範本檔案。You can download the Power BI template file from the Microsoft download center from the Download center. 下載 Power BI 範本檔案之後,請遵循下列步驟開始執行:After you have downloaded the Power BI template file follow these steps to get started:

  1. 開啟 pbit 檔案。Open the pbit file.

  2. 在對話方塊中輸入您的租使用者識別碼值。Enter your tenant id value in the dialog.

    輸入您的租使用者識別碼,以開啟 pbit 檔案

  3. 當系統提示時,請輸入您的系統管理員認證以驗證 Microsoft 365。Enter your admin credentials to authenticate to Microsoft 365 when prompted.

    以取得允許存取 Microsoft 365 使用方式分析報告之使用者的詳細資訊。for more information about who is allowed to access the Microsoft 365 usage analytics reports.

    授權後,就會在 Power BI 檔案中重新整理資料。Once authorized, the data will be refreshed in the Power BI file.

    資料負載可能需要一些時間,完成後,您可以將檔案儲存為 .pbix 檔案,繼續自訂報告或將額外的資料來源帶入此報告。Data load may take some time, once complete, you can save the file as a .pbix file and continue to customize the reports or bring an additional data source into this report.

  4. 遵循 POWER bi 檔快速 入門,以瞭解如何建立報表、將其發佈至 Power BI 服務,以及與您的組織共用。Follow Getting started with Power BI documentation to understand how to build reports, publish them to the Power BI service, and share with your organization. 請遵循此路徑進行自訂和共用,可能需要額外的 Power BI 授權。Following this path for customization and sharing may require additional Power BI licenses. 如需詳細資訊,請參閱 Power BI 授權指南See Power BI licensing guidance for details.