Published: 14 July 2026
Audience
- Admin
- Controller
Objective
This article explains how to connect PSOhub's OData feed to an external reporting tool so you can extract live project data and build your own custom reports.
Prerequisites
You must have Admin or Controller access in PSOhub.
You must have access to a reporting tool that supports OData feeds, such as Microsoft Excel or Microsoft Power BI.
Steps
The example below uses Microsoft Excel. The same OData endpoint and credentials apply when connecting from Power BI or any other OData-compatible tool.
- Open a new Excel file.
- Go to Data > Get Data > From Other Sources > OData Feed.
- Enter the following URL in the OData Feed dialog:
https://www.psohubapp.com/odata/psohub/v2/ - Click OK.
- In the authentication screen, select Basic.
- Enter your PSOhub Username and Password.
- Click Connect.
- Select the data tables you want to include in your report from the Navigator panel.
- Click Load.
- Once the data has loaded, remove any columns you do not need for reporting.
💡 Tip: Keeping only the columns you need improves refresh speed and makes your report easier to work with.
Result
PSOhub data is now available in your reporting tool. The connection is live — refreshing your report pulls the latest data from PSOhub at that moment, with no manual exports required.
Next Steps
✅ Connect OData to Power BI
Set up a live Power BI dashboard by connecting it to your PSOhub OData feed.
Power BI: How to Get Started with PSOhub Data in Power BI
✅ PSOhub OData Reference
Review all available OData tables and fields to understand what data you can pull into your reports.
PSOhub OData Reference
✅ Use the Excel OData report template
Get started faster with a pre-built Excel template already connected to your PSOhub OData feed.
How to Connect an OData Report Template for Excel in PSOhub