From the course: Project Online Reporting with Power BI

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating a data connection

Creating a data connection

From the course: Project Online Reporting with Power BI

Start my 1-month free trial

Creating a data connection

“

- [Instructor] Once you have decided to create a report, you need to have a data connection established and understand what type of data set to include in that report. In this session, we'll build an OData connection to Project Online and understand how the tables I used to create data-enabled reports. I've opened up Power BI Desktop and on the Power BI Desktop, I'm going to select Get Data. Here I can use an OData connection since that's what Project Online uses. So I'll go to the Other option and here I'll find OData Feed and I'll press Connect. Yours should read yourtenant.com/sites/pwa/_api/projectdata. Yours should read yourtenant.com/sites/pwa/_api/projectdata. Each tenant will have a specific URL. Once you've completed your URL, you will press OK. On the left-hand side will be a list of all of the tables that the Project Online environment has available to you. Here you'll see projects, risks, tasks, time…

Contents