PowerBI + HP PPM

[ambpat]

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

[RajanM]

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.

[shailendra986]

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

[v-yuezhe-msft]

@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