使用 Power BI 连接到 SmartsheetConnect to Smartsheet with Power BI

Smartsheet 提供了协作和文件共享的简单平台。Smartsheet offers an easy platform for collaboration and file sharing. Power BI 的 Smartsheet 内容包提供仪表板、报表和显示你的 Smartsheet 帐户概述的数据集。The Smartsheet content pack for Power BI provides a dashboard, reports and dataset that shows an overview of your Smartsheet account. 还可以使用 Power BI Desktop 直接连接到你帐户中的单独工作表。You can also use the Power BI Desktop to connect directly to individual sheets in your account.

连接到 Power BI 的 Smartsheet 内容包Connect to the Smartsheet content pack for Power BI.

备注

最好使用 Smartsheet 管理员帐户连接和加载 Power BI 内容包,因为该帐户具有额外的访问权限。Smartsheet admin account is preferred to connect and load the Power BI content pack as it has additional access.

如何连接How to connect

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

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

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

  4. 对于身份验证方法,选择 oAuth2 > 登录For Authentication Method, select oAuth2 > Sign In.

    出现提示时,输入 Smartsheet 凭据,然后按照身份验证过程进行操作。When prompted, enter your Smartsheet credentials and follow the authentication process.

  5. Power BI 导入数据后,你将在左侧的导航窗格中看到新的仪表板、报表和数据集。After Power BI imports the data you will see a new dashboard, report, and dataset in the left navigation pane. 新的项目会以黄色星号 * 标记,请选择 Smartsheet 条目。New items are marked with a yellow asterisk *, select the Smartsheet entry.

下一步?What now?

包含的内容What's included

Power BI 的 Smartsheet 内容包包含你的 Smartsheet 帐户的概述,例如你拥有的工作区、报表和工作表的数量及其修改时间等。管理员用户还将在看到有关系统中用户的一些信息,如顶层工作表创建者。The Smartsheet content pack for Power BI includes an overview of your Smartsheet account, such as the number of workspaces, reports and sheets you have, when they're modified etc. Admin users will also see some information around the users in their system, such as top sheet creators.

若要直接连接到你帐户中的单独工作表,可以使用 Power BI Desktop 中的 Smartsheet 连接器。To connect directly to individual sheets in your account, you can use the Smartsheet connector in the Power BI Desktop.

后续步骤:Next steps:

Power BI 入门Get started with Power BI

获取 Power BI 的数据Get Data for Power BI