使用 Power BI 連線至資料倉儲Connect to the Data Warehouse with Power BI

適用於︰Azure 上的 IntuneApplies to: Intune on Azure
您需要傳統主控台中之 Intune 的相關文件嗎?Looking for documentation about Intune in the classic console? 請移至這裡Go to here.

您可以下載與 Microsoft Power BI 搭配使用的檔案,以載入 Intune 租用戶的互動式、動態產生的報表。You can download a file for use with Microsoft Power BI that allows you to load interactive, dynamically generated reports for your Intune tenant. 資料倉儲 Power BI 檔案 (pbix) 包含您租用戶的連線設定,以及下列範例報表和圖表:The Data Warehouse Power BI file (pbix) contains connection settings to your tenant, and the following sample reports and charts:

  • 裝置Devices
  • 註冊Enrollment
  • 應用程式保護原則App protection policy
  • 相容性原則Compliance policy
  • 裝置組態設定檔Device configuration profiles
  • 軟體更新Software updates
  • 裝置清查記錄Device inventory logs

另外還有反白顯示註冊、合規性、裝置組態設定檔和軟體更新的趨勢。There are also trends highlighted for the enrollment, compliance, device configuration profile, and software updates. 範例圖表和報表會將使用者易記的篩選套用至畫布。Sample charts and reports apply user-friendly filters to the canvas. 若要使用進階篩選,請參閱 Power BI Desktop 中的 [篩選] 窗格。To use advanced filters, check out the Filter pane in Power BI Desktop.

下列步驟示範如何下載 Power BI 檔案,以及如何搭配使用 OData 連結與 Power BI。The following steps show you how to download the Power BI file and how to use the OData link with Power BI.

安裝 Power BIInstall Power BI

安裝最新版本的 Power BI Desktop。Install the latest version of Power BI Desktop. 您可以從 PowerBI.microsoft.com 下載 Power BI Desktop。You can download Power BI Desktop from: PowerBI.microsoft.com

使用 Power BI 檔案 (pbix) 載入資料和報表Load the data and reports using the Power BI file (pbix)

Power BI 檔案 (pbix) 包含您租用戶的連線資訊以及一組根據資料倉儲資料模型的預先建置報表。The Power BI file (pbix) contains connection information for your tenant and a set of prebuilt reports based on the Data Warehouse data model. 在 Power BI Desktop 中開啟檔案,並登入 Azure AD。Open the file in Power BI Desktop and sign in to the Azure AD. 報表會從 Intune 租用戶載入資料。The report loads the data from your Intune tenant.

重要

每個 Power BI 檔案 (pbix) 可能會根據租用戶位置而有所不同。Each Power BI file (pbix) may be different depending on tenant location. 如果您要管理多個 Intune 租用戶,請務必使用登入該租用戶時從 Azure 入口網站下載的檔案。If you are managing multiple Intune tenants, then be sure to use the file downloaded from the Azure portal while logged in to that tenant.

  1. 登入 Azure 入口網站,並選擇 [監視 + 管理] > [Intune]。Sign in to the Azure portal and choose Monitoring + Management > Intune. 您也可以搜尋 Intune 的資源。You can also search resources for Intune.
  2. 開啟 [Microsoft Intune 資料倉儲 API (預覽)] 刀鋒視窗。Open the Microsoft Intune Data Warehouse API (Preview) blade.
  3. 按一下 Download PowerBI fileClick Download PowerBI file. 副檔名為 (pbix) 的檔案會下載至您指定的位置。The file with a (pbix) extension downloads to the location you specified.
  4. 使用 Power BI 開啟檔案。Open the file with Power BI. Intune Data Warehouse Reports 即會載入,但可能需要一秒才能取得租用戶資料。The Intune Data Warehouse Reports loads, but may take a second as it gets your tenant data.
  5. 按一下 [重新整理] 載入您的租用戶資料以及檢閱報表。Click Refresh to load your tenant data and review the reports.
  6. 如果尚未使用 Azure Active Directory 認證來驗證 Power BI,Power BI 會提示您提供認證。If Power BI has not authenticated with your Azure Active Directory credentials, Power BI prompts you to provide your credentials. 選取您的認證時,請選擇 [組織帳戶] 作為驗證方法。When selecting your credentials, choose Organizational account as your authentication method.

使用向 Azure AD 驗證的用戶端,OData URL 會連線至資料倉儲 API 中向報告用戶端公開資料模型的 RESTful 端點。With a client authenticated to Azure AD, the OData URL connects to the RESTful endpoint in the Data Warehouse API that exposes the data model to your reporting client. 請遵循這些指示,使用 Power BI Desktop 連線並建立您自己的報表。Follow these instructions to use Power BI Desktop to connect and create your own reports. 您不是只能使用 Power BI Desktop,但可以搭配使用最愛的分析工具與 OData URL,但前提是用戶端支援 OAUTH2.0 驗證和 OData 4.0 版標準。You are not limited to Power BI Desktop, but can use your favorite analytic tool with the OData URL provided the client supports OAUTH2.0 authentication and the OData v4.0 standard.

  1. 從報告刀鋒視窗中擷取 OData URL,例如 https://fef.{yourinfo}.manage.microsoft.com/ReportingService/DataWarehouseFEService/dates?api-version=betaRetrieve the OData URL from the reporting blade, for example https://fef.{yourinfo}.manage.microsoft.com/ReportingService/DataWarehouseFEService/dates?api-version=beta.
  2. 開啟 [Power BI Desktop]。Open Power BI Desktop.
  3. 選擇 [首頁] > [取得資料]。Choose Home > Get Data. 選取 [OData 摘要]。Select OData feed.
  4. 選擇 [基本]。Choose Basic.
  5. 將 [OData URL] 鍵入或貼入 URL 方塊。Type or paste the OData URL into the URL box.
  6. 按一下 [ 確定]。Click OK.
  7. 如果尚未從 Power BI Desktop 用戶端向租用戶的 Azure AD 驗證您,請鍵入您的認證。If you have not authenticated to Azure AD for your tenant from the Power BI desktop client, type your credentials.
    a.a. 選取 [組織帳戶]。Select Organizational account.
    b。b. 鍵入您的使用者名稱和密碼。Type your username and password.
    c.c. 按一下 [登入]。Click Sign In.
    d.d. 按一下 [Connect](連線)。Click Connect.
  8. 按一下 [載入]。Click Load.

後續步驟Next steps

您可以找到環境問題的答案,例如上週每日註冊的裝置數目。You can find the answers to questions about your environment such as the number of devices enrolled by day over the last week. 您可以深入了解使用報表的 Intune 租用戶和用戶端母群體,而報表使用 Azure 中刀鋒視窗所擷取的 Intune 資料倉儲 Power BI 檔案 (pbix)。You can gain insight into your Intune tenant and client population using the reports using the Intune Data Warehouse Power BI file (pbix) retrieved from the blade in Azure. 不過,Intune 會提供許多其他的方式,來延伸或重複使用資料。However, Intune provides a number of additional ways to extend or reuse the data. 還有更多方式可以使用 Power BI 和 Intune 資料倉儲 API,例如:There is a lot more that you can do with Power BI and the Intune Data Warehouse API, for example:

  • 已組織您的租用戶資料,協助您從資料中提取深入解析。Your tenant data is organized to help you pull insight from your data. 如需資料組織方式的詳細資訊,請參閱資料倉儲資料模型For more information about how the data is organized, see Data Warehouse Data Model.
若要提交意見反應,請前往 Intune Feedback