Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SK02
Regular Visitor

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

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!

1 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.

View solution in original post

3 REPLIES 3
rajendraongole1
Community Champion
Community Champion

Hi @SK02 

can you please check and make sure you are establishing 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

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!

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.