Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Where can I get a database schema? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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