Answered by:
Where can I get a database schema?

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
- Marked as answer by Raymond Wohltman Friday, August 25, 2017 7:56 PM
Wednesday, August 2, 2017 9:49 PM -
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- Marked as answer by Raymond Wohltman Friday, August 25, 2017 7:57 PM
Wednesday, August 9, 2017 3:32 AM
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?
- Merged by Guillaume Rouyre [MBA, MVP, MCC]MVP Wednesday, August 2, 2017 9:45 PM duplicated
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
- Marked as answer by Raymond Wohltman Friday, August 25, 2017 7:56 PM
Wednesday, August 2, 2017 9:49 PM -
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- Marked as answer by Raymond Wohltman Friday, August 25, 2017 7:57 PM
Wednesday, August 9, 2017 3:32 AM