Project Online:通过 Power BI Desktop 连接到数据Project Online: connect to data through Power BI Desktop

可以通过 Power BI Desktop 连接到 Project Online 中的数据。You can connect to data in Project Online through Power BI Desktop.

步骤 1:下载 Power BI DesktopStep 1: Download Power BI Desktop

  1. 下载 Power BI Desktop,然后运行安装程序,以在计算机上安装 Power BI DesktopDownload Power BI Desktop, then run the installer to get Power BI Desktop on your computer.

步骤 2:通过 OData 连接到 Project OnlineStep 2: Connect to Project Online with OData

  1. 打开 Power BI DesktopOpen Power BI Desktop.
  2. 在“ 欢迎 ”屏幕上,选择“获取数据”。On the Welcome screen, select Get Data.
  3. 依次选择“OData 数据源”和“连接”。Choose OData feed and select Connect.
  4. 在 URL 框中输入 OData 数据源的地址,然后单击确定。Enter the address for your OData feed in the URL box, and then click OK.

    如果你的 Project Web App 站点的地址类似于 https://<tenantname>.sharepoint.com/sites/pwa,那么你将输入的 OData 数据源的地址则为 https:// <tenantname>.sharepoint.com/sites/pwa/_api/Projectdata。If the address for your Project Web App site resembles https://<tenantname>.sharepoint.com/sites/pwa, the address you’ll enter for your OData Feed is https://<tenantname>.sharepoint.com/sites/pwa/_api/Projectdata.

    本示例中,我们使用 https://contoso.sharepoint.com/sites/pwa/default.aspxFor our example, we’re using https://contoso.sharepoint.com/sites/pwa/default.aspx

  5. Power BI Desktop 将提示你使用 Office 365 帐户进行身份验证。Power BI Desktop will prompt you to authenticate with your Office 365 account. 请选择组织帐户,然后输入你的凭据。Select Organizational account and then enter your credentials.

从此处你可以选择想要连接到的表并生成查询。From here, you can choose which tables you would like to connect to and build a query. 想了解如何开始?Want an idea of how to get started? 下面的博客文章将演示如何从你的 Project Online 数据生成燃尽图。The following blog post shows how to build a burndown chart from your Project Online data. 博客文章中使用了 Power Query 连接到 Project Online,Power BI Desktop 也同样适用。The blog post refers to using Power Query to connect to Project Online, but this applies to Power BI Desktop as well.

使用 Power Pivot 和 Power Query 为项目创建燃尽图Creating burndown charts for Project using Power Pivot and Power Query