Updated: 2 March 2026
OData in PSOhub is a secure way to connect, extract, and report on your data in real time using external tools, such as Microsoft Excel or Microsoft Power BI.
With OData in PSOhub, you can:
-
Build real-time dashboards
-
Access data such as projects, time entries, invoices, and expenses
-
Avoid manual exports, because the data stays up to date automatically.
If you’re looking for more detailed or technical information about OData, you can visit the official OData website: https://www.odata.org or watch this quick video.
Connect to OData using Microsoft Excel (example)
Start a new Excel file. Go to Data > Get data > From other sources > OData feed.
Press OK, and you will see the screen below.
Click on Basic and enter your PSOhub user name and password. Then, click Save.
The connection will be made, and all the available OData will be displayed on the next screen.
Select the data tables you want to load and click Load. All the data will be made available within Excel for you to use in your own reports.
Once the PSOhub data tables have loaded, you can remove any unnecessary columns to keep your dataset clean and focused. This helps improve performance and makes your reports easier to work with.
💡Tip: Only keep the columns you need for reporting to ensure faster data refresh and better usability.
⚠️ Important note: In the uncommon event that you are experiencing errors when loading your OData feed, there is a chance that you might have data that contains an apostrophe (') symbol. Various reporting tools are known to have issues processing this symbol. A solution can be to switch from the default UTF-8 to UTF-16 encoding. You can find information on how to do this in the documentation of the reporting software you are using.
Related articles
Power BI
PSOhub OData Model
PSOhub OData Reference
Odata sends data source error message "... column does not exist"
Connect OData report template for Excel
Discrepancy between time entries in OData extract & PSOhub