Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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...
Thanks,
Lydia Zhang
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).
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.
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
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 Zhang
HI @v-yuezhe-msft,
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
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...
Thanks,
Lydia Zhang
Hi @v-yuezhe-msft,
I've been able to use the path as parameter ! Thanks !
If I want to share the report to my organization user online - they use Power BI online (not Desktop) - will they be able to define the path (the path parameter) themself ?
I hope you understand my point... I may be not clear enough.
Thks
Pierre
Hi @pierredelareux,
Parameters are only be able to edited in Power BI Desktop but not in Power BI Service.
Thanks,
Lydia Zhang
Ok...
Will it be improved later ?
@v-yuezhe-msft thanks for the link, I really appreciate it.
@pierredelareux can you please provide more information about your case, do you have one Primavera database or every planner has his own installation, who update PowerBI, is it you or the planner responsability, do you have free PowerBI or Pro
PowerBi is so flexible, you can do a lot of different integration scenarios.
Hi @mim,
We are using one DB for all users.
The goal is to allow every users - planner level - to export their own project in XML and then upload it to Power BI to use the template I set.
The best solution would have been to use Online Power BI to import XML project... Next features maybe
Pierre
Thanks Pierre
i see, but reading from xer or xml can be tricky specially for spread data as it is not stored in the file, at work, we do export excel from P6, and do the reports in PowerBI
thanks again for the reply as it seems not a lot of planners are aware of PowerBI
cheers
Mim
This is the error message I get when I try to use Oracle DB connectors.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |