Call Us Today! 1-800-895-3254
[email protected]
Microsoft Training
Integent offers a comprehensive portfolio of training services, with an ideal fit for every organization. Ranging from general courses to custom solutions, we have you covered.
Learn About TrainingSee Full list of Courses
Microsoft Consulting
Integent provides consulting services for a variety of Microsoft applications including Microsoft Project, Project Online, Project for the Web, Dynamics 365, and Microsoft SharePoint.
Learn About Consulting
Microsoft Support
Microsoft technologies set the standard for project portfolio management, business applications, collaboration, and more. Integent has flexible solutions to support every customer.
Learn About Support
Microsoft Project
Integent has the knowledge and experience to help design and deploy a solution to help your organization manage projects and resources more effectively
Learn More About Microsoft Project
Microsoft Dynamics 365
Integent can help you nsure business continuity with a custom cloud solution that connects sales, service, finance, and operations teams to deliver results.
Learn More About Dynamics 365
Microsoft SharePoint
SharePoint is Microsoft’s collaboration platform that is a place where team members can communicate, exchange data, share files and much more.
Learn More About Microsoft SharePoint
Microsoft Power Platform
Consisting of Power BI, Power Apps, Power Automate and Power Virtual Agents, the Microsoft Power Platform helps streamline and improve business functions.
Learn More About The Power Platform
About Integent
Integent was founded in 2009 on the principles of building long-lasting relationships with customers, exceeding expectations, and providing outstanding customer service. 

We’re dedicated to providing a customized solution backed by our knowledgeable team of Microsoft experts.
Discover What Makes Us Different
GSA Schedule
Integent is GSA Schedule Contract holder. A GSA schedule helps simplify selling our services to government customers.
Read More Here
Stay informed on Integent’s latest company updates and other important industry information. Our passion is customer success.
Read The Latest News
Learning new software doesn’t have to be difficult with our library of dozens of free training videos. Our video training always has something new.
Browse Our Training Video Library
Our industry experts share best practices and common pitfalls to avoid, in order to get the most out of your technology solutions.
Discover More

August 29, 2019

How To Connect Project Online with Excel via OData

Looking to create a connection from your Project Online environment to Excel? Excel is a powerful and one of the most commonly used reporting tools for Project Online. Excel allows you to pull, refresh, and transform data so it’s customized for your organization’s reporting needs.
Project Online uses OData feeds to pull the information from of Project Online. There are two ways to connect to the data using Excel:
  1. Get Data using OData (newer version)
  2. Get Data using OData (Legacy version)
If you are using an older version of Excel, the legacy version may be the only option available to you.

Get Data using OData (newer version)

  • In the ribbon, click on the Data tab. Select Get Data, then From Other Sources, then From OData Feed.

  • From the browser, navigate to your PWA site and copy the URL through PWA as shown below.

  • Paste the copied URL in the OData Feed dialog box and add “/_api/projectdata” to the end. Click OK.

Note: Memorizing this ending to the OData feed will improve efficiency when building out reports!

*It may ask you to authenticate using your PWA credentials.

  • In the Navigator, click “Select multiple items” and choose the relevant tables to the report you are going to build. Once finished, click Load to import the tables into the workbook.

Note: The preview pane on the right will display a small sample of the data that is in the tables.

WARNING: Loading very large tables can take a long time.

  • Using this Get Data method, the table will appear as queries on the right panel.

Legacy Method

  • In the ribbon, click on the Data tab. Select Get Data, then Legacy Wizards, then From OData Data Feed (Legacy)
  • Copy and paste the your PWA URL in the Link or File box and add “/_api/projectdata” to the end. Confirm “Use the sign-in information for the person opening this file” is selected. Click OK.

*It may ask you to authenticate using your Project Online credentials.
  • In the Data Connection Wizard box, select the relevant tables to the report you are looking to build.

  • These settings can be left with defaults. A description of the table can be added here if you’d like. Click Finish.
WARNING: Loading large tables can take a long time.
  • In the Import Data dialog box, select “Only Create Connection” then click OK. This will add the table information to the Data Model.
Note: The status of “Retrieving Data…” can be seen in the bottom bar as data is added. This message will also display when the report is Refreshing Data
  • When using this method, the tables will appear as Connections in the panel on the right side (Queries & Connections).
Note: You can turn on the option for the Legacy version by going to your Excel Options and selecting the check box next to Get OData (Legacy). After checked, it will be an available option under Get Data > Legacy Wizards.
Which method do you prefer when creating your connections with Excel?
© Copyright 2023 | | All Rights Reserved
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram