cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pierredelareux
Helper I
Helper I

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

1 ACCEPTED 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

14 REPLIES 14
EmilieBa
New Member

Hi @pierredelareux

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

v-yuezhe-msft
Microsoft
Microsoft

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 .
1.PNG2.PNG3.PNG5.PNG

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yuezhe-msft,

 

I have to use parameter to let them "upload" their file ?

 

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...

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

pierredelareux
Helper I
Helper I

image.jpg

 

 

 

 

 

 

 

 

 

 

This is the error message I get when I try to use Oracle DB connectors.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors