To do this, we will base ourselves on the Activity Code called Project 2080. Next, we are going to see an example that shows how the data that we enter in P6 is stored within its database. Example of where data is written to the Primavera database It should be noted that calculated fields are not stored in the Primavera database, since they are calculated based on other fields in the database. Despite the large number of tables that the Primavera P6 database contains, we should be more familiar with only 20 of them.

These tables are referenced to each other through relationships between a Primary Key and a Foreign Key. Each of these tables contains different fields which in turn contain records. The Primavera P6 project planning tool database stores all data in more than 170 tables. What to find in a Primavera P6 XER file How is data stored in the Primavera P6 database That’s why we think that working directly with XER files as data sources will save us a lot of manual work in the long run and greatly reduce the risks that come with working with manually created spreadsheets.īefore showing you how to connect the Primavera P6 XER file to Power BI, let’s see what’s behind the native XER file of this powerful project planning and control tool that is Primavera P6. However, it can become a process that generates errors more easily or is not 100% automatic. The use of excel spreadsheets is a process that, today, is certainly friendly for most users.

Converting p6 file to ms project