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.
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!
Super UserTo 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.