To facilitate business intelligence (BI) requirements, PPO provides an API by means of an OData restful service. OData is an open protocol which is widely supported by numerous vendors.
Follow this article that explains how to access the BI API, connect your BI Tool to PPO to export data as well as the basics of doing this with Excel as well as Power BI.
The linked document below explains all you need to know.