Forum Discussion
How to get custom fields from Project Web app into Power BI
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.
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
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.
