Assignment Owner column in Power BI RRS feed

  • Question

  • Hello, 

    I use Project Web App to track and govern Projects. And Power BI to use the data from SharePoint and create reports. In what column and table can I find 'Assignment Owner' in Power BI? I need to figure for which tasks the resource name and assignment owner names are not matching. Any help would be much appreciated.

    Thank you,


    Monday, August 20, 2018 8:43 AM


  • Hello,

    From memory I dont believe the Assignment Owner is available in the OData Reporting (_api/ProjectData) API. Pretty sure you can get this from the CSOM REST  (_api/ProjectServer) API though. But it you would need to get the project, get the Assignments, then for the Assignments get the Owner and then get the Resource.


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    • Marked as answer by PWMatherMVP Wednesday, October 10, 2018 10:40 PM
    Monday, August 20, 2018 12:37 PM