none
Where can I get a database schema? RRS feed

  • Question

  • I understand the database structure has changed from 2013 to 2016, where can I get documentation that I can print out on the 2016 database schema so I can begin to use Power BI to develop reports?

    Thanks, Ray Wohltman

    Wednesday, August 2, 2017 5:22 PM

Answers

  • You don't need to have PS DB schema to report with odata, just know the entities.

    Here is an good overview:

    https://www.senseiprojectsolutions.com/2016/02/15/power-bi-for-project-online-get-started-quickly/

    That being said, you can always download the 2013 SDK which will give you the reporting DB schema:

    https://www.microsoft.com/en-us/download/details.aspx?id=30435


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Wednesday, August 2, 2017 9:49 PM
    Moderator
  • Hello Ray

    There isn't a SDK for Project 2016 

    https://social.msdn.microsoft.com/Forums/en-US/142a5f86-be23-476d-8c0d-2a73df259641/from-where-we-can-download-project-2016-sdk-?forum=project2010custprog

    However, the 2013 database schema is close to what it is found in 2016.  They are similar enough to help with reporting.  As you probably already know,  the biggest difference is the schema name that is used and the data structures are nested in a SharePoint content database.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Wednesday, August 9, 2017 3:32 AM
    Moderator

All replies

  • Hello, I understand the database schema has changed from 2013 to 2016, where can I get info / documentation on the database schema so I can print out and use in reports?
    Wednesday, August 2, 2017 5:25 PM
  • You don't need to have PS DB schema to report with odata, just know the entities.

    Here is an good overview:

    https://www.senseiprojectsolutions.com/2016/02/15/power-bi-for-project-online-get-started-quickly/

    That being said, you can always download the 2013 SDK which will give you the reporting DB schema:

    https://www.microsoft.com/en-us/download/details.aspx?id=30435


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Wednesday, August 2, 2017 9:49 PM
    Moderator
  • Hello Ray

    There isn't a SDK for Project 2016 

    https://social.msdn.microsoft.com/Forums/en-US/142a5f86-be23-476d-8c0d-2a73df259641/from-where-we-can-download-project-2016-sdk-?forum=project2010custprog

    However, the 2013 database schema is close to what it is found in 2016.  They are similar enough to help with reporting.  As you probably already know,  the biggest difference is the schema name that is used and the data structures are nested in a SharePoint content database.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Wednesday, August 9, 2017 3:32 AM
    Moderator