使用 Power BI 连接到 UserVoiceConnect to UserVoice with Power BI

借助 Power BI 和 UserVoice 内容包,可轻松跟踪和浏览你的 UserVoice 数据。Tracking and exploring your UserVoice data is easy with Power BI and the UserVoice content pack. Power BI 可以检索你的数据,包括票证和满意度,然后基于该数据生成全新的仪表板和报表。Power BI retrieves your data, including tickets, suggestions and satisfaction ratings, then builds an out-of-box dashboard and reports based on that data.

连接到适用于 Power BI 的 UserVoice 内容包Connect to the UserVoice content pack for Power BI.

备注

连接到 Power BI 内容包需要管理员帐户。An admin account is required to connect to the Power BI content pack. 此内容包还利用 UserVoice API,并会增加 UserVoice 限制的使用情况。The content pack also leverages the UserVoice API and will contribute usage towards the UserVoice limits. 请参阅以下详细信息。More details below.

如何连接How to connect

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

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

  3. 选择 UserVoice,然后选择获取Select UserVoice, then select Get.

  4. 出现提示时,输入你的 UserVoice URL。When prompted, enter your UserVoice URL. URL 需要完全遵循以下模式 https://fabrikam.uservoice.com 并将“fabrikam”替换为你的产品或服务名称。The URL needs to follow the following pattern exactly https://fabrikam.uservoice.com replacing "fabrikam" with your product or service name.

    备注

    末尾没有尾部斜杠,并且连接使用的是 https。There is no trailing slash at the end and the connection is in https.

  5. 出现提示时,输入 UserVoice 凭据,然后按照 UserVoice 身份验证过程执行。When prompted, enter your UserVoice credentials and follow the UserVoice authentication process. 如果你已经在浏览器中登录到 UserVoice,可能不会出现凭据提示。If you are already signed in to UserVoice in your browser, you may not be prompted for credentials. 通过单击“允许访问”授予 Power BI 应用程序访问数据的权限。Grant the Power BI application access to your data by clicking "Allow Access".

    备注

    你的 UserVoice 帐户需要管理员凭据。You need admin credentials for your UserVoice account.

  6. Power BI 会检索 UserVoice 数据,并为你创建随时可用的仪表板和报表。Power BI will retrieve your UserVoice data and create a ready-to-use dashboard and report for you. Power BI 将检索下列数据:你的所有建议,所有开放票证,最近 30 天创建的票证,包括已关闭的票证和所有用户满意度。Power BI will retrieve the following data: all your suggestions, all your open tickets, all tickets created in the last 30 days including closed ones and all the user satisfaction ratings.

下一步?What now?

故障排除Troubleshooting

“参数验证失败,请确保所有参数都是有效的”"Parameter validation failed, please make sure all parameters are valid"

如果键入 UserVoice URL 后看到此错误。If you see this error after typing your UserVoice URL. 请确保满足以下要求:Make sure the following requirements are satisfied:

  • URL 完全采用这种模式“https://fabrikam.uservoice.com”,并将“fabrikam”替换为正确的 UserVoice URL 前缀。The URL follows exactly this pattern "https://fabrikam.uservoice.com" replacing "fabrikam" with your correct UserVoice URL prefix.
  • 请确保所有字母均为小写。Make sure all the letters are lower case.
  • 请确保 URL 采用的是 httpsMake sure the URL is in 'https'.
  • 请确保此 URL 的末尾没有尾随正斜杠。Make sure there are no trailing forward slash at the end of the URL.

“登录失败”"Login failed"

在使用 UserVoice 凭据进行登陆后,若出现“登录失败”,则表明所使用的帐户无权从你的帐户中检索 UserVoice 数据。If you get a "login failed" error after using your UserVoice credentials to login, then the account you are using doesn't have permissions to retrieve the UserVoice data from your account. 验证其是否为管理员帐户,然后重试。Verify it is an admin account and try again.

很抱歉,出现了错误"Oops something went wrong"

如果在加载数据时收到此错误消息,请确保你的 UserVoice 帐户尚未超过其每月的 API 使用配额。If you get this error message while the data is being loaded, make sure your UserVoice account hasn't exceeded its monthly APIs usage quota. 如果一切正常,请尝试重新连接。If all looks good, try connecting again. 如果问题仍然存在,请联系 Power BI 支持:https://community.powerbi.comIf the problem persists, please contact Power BI support at https://community.powerbi.com.

其他Other

Power BI UserVoice 内容包使用 UserVoice 的 API 检索数据。The Power BI UserVoice content pack uses UserVoice's APIs to retrieve your data. 请确保监视你的 API 使用情况,以便使其不超出限制。Make sure you monitor your API usage so that you don't exceed your limit. 如果你的 UserVoice 帐户中拥有大量数据,将 API 使用情况影响降到最低的建议是:根据需要,将当前默认的刷新频率(每天一次)更改为仅在工作日或每隔一天刷新一次。If you have a lot of data in your UserVoice account, a suggestion to minimize the impact on your API usage is to change the refresh frequency from the current default which is once a day to only refresh on weekdays or every other day depending on your needs. 另一个建议是:只让一名管理员创建内容包并将其共享给团队中的其他人,而不是让组织内的每个管理员都来创建其自己的内容包,为 API 带来不必要的额外负载。Another suggestion is to have one admin create the content pack and share it with the rest of the team instead of having every admin in your organization create their own putting extra unnecessary load on the APIs

后续步骤Next steps

Power BI 入门Get started in Power BI

在 Power BI 中获取数据Get data in Power BI