Forum Discussion

pierredelareux's avatar
pierredelareux
Helper I
9 years ago
Solved

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 ...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

pierredelareux's avatar
pierredelareux
Helper I
9 years ago

HI 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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