使用 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 BI 入门Get started with Power BI

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