Project Server (Office 365) Get Project Risks data RRS feed

  • Question

  • Hi

    I'm new to project server online (office 365).

    I have a Project server online on Office 365 and I want to query all the projects and its Risks as an excel file. The Risks SharePoint uses OOTB content types and few custom column added to the list. I was told that the OOTB office data connection file for Risks does not retrieve the custom columns and I was tasked to fix this issue. 

    I'm completely new to project server and could someone tell me how this can be accomplished. If I create a new data connection file will I be able to use SQL Query or using SQL Query is not allowed in Office 365 since the database is not known.

    If using SQL Query is not an option how can I query the OOTB columns + the custom columns for all the projects.

    I want to use the ODC file to generate Excel file which then can be used for different views like power pivot etc.,



    Tuesday, September 16, 2014 11:23 AM