使用 Power BI 连接到 ZendeskConnect to Zendesk with Power BI

Zendesk 内容包提供 Power BI 仪表板和一组 Power BI 报表,这些报表提供有关你的票证量和代理性能的深入分析。The Zendesk content pack offers a Power BI dashboard and a set of Power BI reports that provide insights about your ticket volumes and agent performance. 可以使用提供的仪表板和报表,或自定义它们以突出显示你最关注的信息。You can use the dashboard and reports provided, or customize them to highlight the information you care most about. 此数据将每天自动刷新一次。The data will be refreshed automatically once a day.

连接到 Zendesk 内容包或进一步了解 Power BI 与 Zendesk 集成Connect to the Zendesk content pack or read more about the Zendesk integration with Power BI.

备注

需要使用 Zendesk 管理员帐户进行连接。A Zendesk Admin account is required to connect. 以下是有关要求的详细信息。More details on requirements below.

如何连接How to connect

  1. 选择左侧导航窗格底部的获取数据Select Get Data at the bottom of the left navigation pane.

  2. 服务框中,选择获取In the Services box, select Get.

  3. 选择 Zendesk > 获取Select Zendesk > Get.

  4. 提供与你的帐户相关联的 URL。Provide the URL associated with your account. 它将采用 https://company.zendesk.com 形式,有关详细信息,请参阅下方的查找这些参数This will be in the form https://company.zendesk.com, see details on finding these parameters below.

  5. 出现提示时,输入你的 Zendesk 凭据。When prompted, enter your Zendesk credentials. 选择 oAuth 2 作为身份验证机制,然后单击登录Select oAuth 2 as the Authentication Mechanism and click Sign In. 按照 Zendesk 身份验证流程进行操作。Follow the Zendesk authentication flow. (如果你已经在浏览器中登录到 Zendesk,可能不会提示你输入凭据。)(If you are already signed in to Zendesk in your browser, you may not be prompted for credentials.)

    备注

    内容包需要使用 Zendesk 管理员帐户连接。This content pack requires you connect with a Zendesk Admin account.

  6. 单击允许以允许 Power BI 访问你的 Zendesk 数据。Click Allow to allow Power BI to access your Zendesk data.

  7. 单击“连接”以开始导入过程。Click Connect to begin the import process. Power BI 导入数据后,你会在左侧的导航窗格中看到新的仪表板、报表和数据集。After Power BI imports the data, you see a new dashboard, report, and dataset in the left navigation pane. 新的项目会以黄色星号 * 标记。New items are marked with a yellow asterisk *.

下一步?What now?

包含的内容What's included

Power BI 内容包中包括下列数据:The Power BI content pack includes data on the following:

  • 用户(最终用户和代理)Users (end users and agents)
  • 组织Organizations
  • Groups
  • 票证Tickets

还有一组计算所得度量值,如平均等待时间和过去 7 天解决的票证。There's also a set of measures that have been calculated, such as Average Wait Time and Tickets Solved in the Last 7 days. 内容包中包含完整列表。A full list is included in the content pack.

系统要求System requirements

访问 Zendesk 内容包需要 Zendesk 管理员帐户。A Zendesk Administrator account is required to access the Zendesk content pack. 如果你是代理或最终用户,想要查看你的 Zendesk 数据,请在 Power BI Desktop 中添加建议并察看 Zendesk 连接器。If you're an agent or an end user and are interested in viewing your Zendesk data, please add a suggestion and review the Zendesk connector in the Power BI Desktop.

查找参数Finding parameters

Zendesk URL 将与你用于登录 Zendesk 帐户的 URL 相同。Your Zendesk URL will be the same as the URL you use to sign into your Zendesk account. 如果不能确定你的 Zendesk URL,可以使用 Zendesk 登录帮助If you're not sure of your Zendesk URL, you can use the Zendesk login help.

故障排除Troubleshooting

如果遇到连接问题,请检查你的 Zendesk URL,确保使用的是 Zendesk 管理员帐户。If you are having issues connecting, please check your Zendesk URL and confirm you're using an Zendesk administrator account.

后续步骤Next steps