Connect Power BI or Excel
Build your own reports by reading UProject's data through an OData feed.
UProject has no report builder of its own: for free-form analysis, tools such as Power BI, Excel and Tableau read the data through an OData feed. You see projects, tasks, assignments, clients and people, always only what your role allows (people only for admin and PM).
Create the access token
- Click your name in the top right corner and choose My account.
- Under Access for BI tools, give the token a name (for example, Power BI on my laptop) and click Create token.
- Copy the token right away: it does not appear again. If you lose it, revoke it and create another.
Connect
- Power BI Desktop: Get data › OData feed › paste the feed address (it appears in My account).
- Excel: Data › Get data › From other sources › From OData feed.
- For authentication, choose Basic: user = your email; password = the token you created.
Tip: Each token sees the same as your user. To stop an access, revoke the token in My account.