Forum Discussion

SK02's avatar
SK02
Regular Visitor
2 years ago
Solved

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!

Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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.

3 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    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's avatar
      SK02
      Regular Visitor
      2 years ago

      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's avatar
        rajendraongole1
        Super User
        2 years ago

        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.