Forum Discussion

ambpat's avatar
ambpat
New Member
9 years ago

PowerBI + HP PPM

Hi All,

Here is my requirement:

My team is planning to maintain projetcs in HP PPM. 

Reporting will be done through Microsoft PowerBI. 

 

Is it possible to integrate HP PPM with Microsoft PowerBI so that powerBI can direclty read data from HP PPM project plans?

 

Appreciate inputs here. Request is a little urgent.

Thanks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    ambpat,

    There is no built-in connector for HP PPM in Power BI. However, based on my research, HP PPM provides JSON based web service. For more details, please review this similar thread.

    You can use “Get Data->Web” entry in Power BI Desktop or directly add connection information in Advanced Editor to connect to the JSON web service. There are some samples for your reference.

    Power BI - Connect to your secure API
    API Strategies with Power BI
    Connect with secure JSON source

    Regards,
    Lydia

  • RajanM's avatar
    RajanM
    New Member
    8 years ago

    Yes you can use PowerBI to connect to HP PPM its an oracle DB but you need to know the base tables of HP PPM and how to query the tables. I can help you still are looking for it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Can we consume PPM web page directly using search id URL?