Forum Discussion
Primavera Datas
Hi,
I would like to use Power BI to see and analyse datas coming from Primavera P6, an Oracle tool.
Should I use web service ? SQL requests ?
How do I log into the P6 data-base ?
I hope you will be able to help me.
Thanks
Pierre
Hi pierredelareux,
Yes. You can take a look at the following similar thread about this scenario.
https://community.powerbi.com/t5/Desktop/How-to-create-a-template-with-a-different-data-source-every-time/td-p/50969
Thanks,
Lydia Zhang
16 Replies
This is the error message I get when I try to use Oracle DB connectors.
Hi pierredelareux,
There is no built-in connector for Primavera in Power BI Desktop. An idea about this issue has been submitted in this link , please vote it up.
Additionally, to work around this issue, you can use Power Query to connect to Primavera xer files and create charts in PowerPivot following the guide in this blog, then pin these charts to Power BI dashboard following the instructions in this article.
Moreover, you can try to put all Primavera xer files in a folder, then use “Get data->File->Folder” entry in Power BI Desktop to connect to these xer files. Then paste the code of Advanced Editor in Power query to Advanced Editor in Power BI Desktop to parse these Primavera xer files .
Thanks,
Lydia ZhangHI Anonymous,
Thks for you r answer.
It seems to be a bit to complex for me and my users can't donwload the XER file.
I am on the way to define a Power BI report template and let them upload their own data by getting a Excel file from BI Publisher.
Does it seem to be suitable ?
Pierre
Hi pierredelareux,
Do you want to export data from Primavera P6 to Excel and then connect to the Excel from Power BI Desktop and create report template? If that is the case, it is suitable, other users can use the Power BI template file to instantiate new Power BI reports.
Thanks,
Lydia Zhang
Did you find a way to link with primavera data ?
We are using for primavera an SQLServer, apparently we can connect using PXRPT user. I'll try
If for you it's working can you please explain how you access it
Thanks
Hi EmilieBa,
No I didn't find any way.
We are using P6 Cloud and Oracle blocks all entries.
I also tried to use PXRPT User but I didn't get access.
I hope you will find a way
Pierre
Mustang Technologies developed an integration to Oracle Hosting/OCI called P6ETL™. P6ETL™ extracts the data from the Primavera P6 database using P6 Web Services and then P6ETL™ creates a reporting database (the P6ETL™ SQL Server database). Then users can connect Power BI to the P6ETL™ database and create Power BI reports. To learn more, go to www.p6etl.com
However – if you just want to connect Power BI to the P6 DB, check out this LinkedIn Group: https://www.linkedin.com/groups/13914226/ I created a couple videos in the group to demonstrate how to create Power BI reports for P6.
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).
