使用 Power BI 連接到 ServiceNow 以取得事件報告Connect to ServiceNow with Power BI for incident reporting

ServiceNow 提供多樣產品與解決方案,包括商務、營運與 IT 管理,進而提升您的業務發展。ServiceNow offers multiple products and solutions including business, operations and IT management to improve your business. 這個內容套件包括多個報表與深入解析,為您開放、最近解決與最近關閉的事件提供資訊。This content pack includes multiple reports and insights on your open, recently resolved and recently closed incidents.

連接至適用於 ServiceNow 事件的 Power BI 內容套件。Connect to the Power BI content pack for ServiceNow Incidents.

如何連接How to connect

  1. 選取左側瀏覽窗格底部的 [取得資料] 。Select Get Data at the bottom of the left navigation pane.

  2. 在 [服務] 方塊中,選取 [取得] 。In the Services box, select Get.

  3. 選取 [ServiceNow 事件] > [取得]。Select ServiceNow Incidents > Get.

  4. 提供 ServiceNow 執行個體的 URL 以及要帶入的天數/記錄範圍。Provide the URL of your ServiceNow instance and the range of days/records to bring in. 請注意,只要達到一項限制,即停止匯入。Note as soon as one limit is hit the import will stop.

  5. 出現提示時,請輸入您的 ServiceNow 基本認證。When prompted, enter your ServiceNow Basic credentials. 請注意,目前不支援單一登入,系統需求的詳細資料如下。Note single sign on is not supported today, more details on the system requirements below.

  6. 一旦完成登入流程就會開始匯入程序。Once the login flow is completed the import process will begin. 完成時,新的儀表板、報表和模型會出現在瀏覽窗格中。When complete, a new dashboard, report and model will appear in the Navigation Pane. 選取儀表板以檢視匯入的資料。Select the dashboard to view your imported data.

接下來呢?What now?

系統需求System requirements

若要連線,您需要:To connect you will need:

  • 可以使用基本驗證存取 yourorganization.service-now.com 的帳戶 (此版本不支援單一登入)An account that can access yourorganization.service-now.com with Basic authentication (Single Sign-On is not supported in this version)
  • 帳戶必須有 rest_service 角色與事件資料表的讀取存取The account must have rest_service role and read access to incident table

疑難排解Troubleshooting

如果您在載入期間遇到認證錯誤,請檢閱上方存取需求。If you're hitting a credential error during load, please review the access requirements above. 如果您有正確的權限,但仍遇到問題,請洽詢您的 ServiceNow 管理員以確認自訂執行個體是否需要其他任何權限。If you have the correct permissions and are still hitting issues, please work with your ServiceNow admin to ensure you have any additional permissions that may be required for your custom instance.

如果載入時間過長,請檢閱您在連線期間指定的事件數目與天數,並考慮減少該數目。If you're seeing long load times, please review the number of incidents and number of days you specified during connection and consider reducing it.

後續步驟Next steps

開始使用 Power BIGet started with Power BI

Power BI - 基本概念Power BI - Basic Concepts