Log in to Project Online with Excel

Excel is a tool that can be used for reporting on data in Project Online via OData and Project Online's API.  If you want to read the data from Project Online, it must be set to allow you to access and read the datasets.  If permission has already been enabled, you'll need to enter your credentials. 

If you haven't yet designed the report, check out the article on Connecting to Project online OData using Excel.  This article discusses the process of authenticating and not connecting.  You'll find these instructions useful if your password changes, you receive this report for the first time, or you just downloaded it.  Typically, once you authenticate, the report will cache and continue to use the credentials unless you open the Excel file on another computer.

Follow these steps to authenticate with Project Online:

Step 1

• Assuming the report is already built, and you receive a security warning, click Enable Content in the yellow banner.

Step 2

• In the Ribbon, select the Data tab
• Select the Get Data drop-down
• Select the Data Source Settings… menu item

Step 3

• Click the Edit Permissions… button.

Step 4

• Click the Edit… button

Step 5

• Select Organizational account and click Sign In.  Enter your username and password.  
• If you receive a forbidden error, check to make sure you've been given permission in Project Online to access the reporting data.  You may need to reach out to your Project Online administrator.

Step 6

Once you've successfully signed in.  You should see this screen.

• Click Save
• Click Ok
• Click Close

Step 7

• Click Refresh All.  The report will connect to Project Online to retrieve data.  It should take a few minutes.