How to get custom fields from Project Web app into Power BI

[SK02]

In Power BI desktop, I have connected to Project Web app (PWA Project) through OData feed connector, I got columns which are their in Project Online but I couldn't get the custom field columns. Is there any way to get those custom field columns in to Power BI. Are other ways to get those columns/Project without going through OData Feed.

Thank you!

[rajendraongole1]

Hi @SK02 

can you please check and make sure you are establishing a connection to the correct endpoint, which is usually /sites/pwa/_api/ProjectData. Link up to the endpoint for ProjectData: Select Get Data > OData Feed in Power BI. Like example projectData OData endpoint URL, for example, https://<yourtenant>.sharepoint.com/sites/pwa/_api/ProjectData. Locate the entity that has custom fields by navigating through the others.Tables with names like Tasks, Projects, or Assignments may contain custom fields.

Try it solution and let know

Regards,

Rajendra

[SK02]

I am able to get the 'Tasks' table into PBI but I don't see three specific custom coulmns (that is created in PWA). How do I get them.

Thank you!

[rajendraongole1 · Accepted solution]

To locate the entity that contains custom fields, navigate through the options available. Custom fields are often found within tables such as Tasks, Projects, or Assignments.

check or you can also try with rest api from power query editor

or

Create a custom query in Power BI:

Go to Home > Get Data > Blank Query.
In the Advanced Editor, write a query to fetch data using the Project Online REST API.
Example REST API query: https://<yourtenant>.sharepoint.com/sites/pwa/_api/ProjectServer/Projects?$select=Id,Name,Custom_x0020_Field1,Custom_x0020_Field2.
Authenticate if required (usually OAuth or other SharePoint authentication methods).

Transform the data as needed once it is loaded into Power BI.