Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Aishwarya96
New Member

Power BI connection with P6 EPPM

can we connect power bi with P6 EPPM?

3 REPLIES 3
equivtech
New Member

Look at PSIX Extractor, you can choose required columns and filter data as like P6 professional filtering and application extract data from any P6 Database located in any cloud, you can export more than 500+ columns from the backend, and application is using P6 webservices in the backend, you ddont need any developer to do any programming. if you know P6 then you can run the application. PSIX extractor works as integration tool as well

https://www.equivtech.com.au/Oracle-Primavera-P6-Extractor-Software.html 

paulciszewski33
Frequent Visitor

If your P6 EPPM or Oracle Primavera Cloud (OPC) is hosted at Oracle, Oracle makes it difficult to connect Power BI to the P6 EPPM or OPC DB.  You need to extract the P6 or OPC data out of Oracle Hosting using a utility such as P6ETL (www.p6etl.com).  Actually, P6ETL can extract P6 data out of any hosted environment such as Loadspring.  P6ETL then stores the P6 or OPC data into a MSSQL DB (on-premise, at Azure, or at AWS).  Once the P6 or OPC data is in the MSSQL DB, you can create Power BI P6 and OPC dashboards.  And P6ETL will automatically update/refresh the P6 and OPC data in the MSSQL DB throughout the day

 

But, if your P6 DB is on-premise, you can connect Power BI to your P6 Native DB.  Checkout the “Primavera P6 Reporting with Microsoft Power BI” LinkedIn group (https://www.linkedin.com/groups/13914226/).  There are a few videos to show you the steps for connecting Power BI to your on-premise P6 DB.

 

And if you are using P6 EPPM on-premise and Publishing is enabled, you also have access to the P6 Report DB (which has most calculated and time-phased data).

amitchandak
Super User
Super User

@Aishwarya96 ,  is it Primavera P6?

 

https://www.youtube.com/watch?v=X5-3gEP8wrQ

 

https://project2080.com/en/primavera-p6-database-connection-to-power-bi/

https://project2080.com/en/connect-primavera-p6-to-power-bi/

https://planningdojo.com/oracle-primavera-p6/link-primavera-and-power-bi-quick-start-guide/5341/

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.