Forum Discussion

John_DeKock's avatar
John_DeKock
Helper I
7 months ago
Solved

Owner/Contact Field on reports

Hi PBI Community

 

Would appreciate if anyone could assist here? I need this field... Is there anyway to get hold of the data? API maybe?

 

Best regards 

 

  • Hi John_DeKock

    you can get the information of the owner via the Power BI API. See the documentation here:

    Admin - Reports GetReportUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

    The field "reportUserAccessRight" should be the one where you take the "Owner".

     

    Note: You need Admin API access to retrieve contact info for all reports across the tenant.

     

    Best regards!

    PS: If you find this post helpful consider leaving kudos or mark it as solution

     

  • Hi, 

     

    Did you mean whether the 'Contact' can be accessed via DAX in Power BI Visuals or report? If this is what you meant, the 'Contact' field shown in the report settings is service-level metadata used for governance only. It is not part of the dataset and cannot be accessed on report. If you need to display an owner/contact, i'd suggest storing it in a table (e.g., SharePoint or Excel) and model it explicitly.

  • Hi John_DeKock and durham4 ,

    Thank you for the follow up and for sharing your findings.

     

    To clarify, the Reports REST API, including Get Reports in Group, does not return the Contact field configured in the Service. That property is not currently exposed through Reports APIs, Admin APIs, or Scanner APIs.

     

    If the requirement is specifically to identify who actually created or published a report, the supported approach today is to review the Power BI Activity Log and check the relevant report creation or publish events.

    There is no dedicated REST API property that directly returns the original publisher or the Contact value.

     

    Please reach out for further assistance.
    Thank you.

9 Replies

  • Hi, 

     

    Did you mean whether the 'Contact' can be accessed via DAX in Power BI Visuals or report? If this is what you meant, the 'Contact' field shown in the report settings is service-level metadata used for governance only. It is not part of the dataset and cannot be accessed on report. If you need to display an owner/contact, i'd suggest storing it in a table (e.g., SharePoint or Excel) and model it explicitly.

  • Hi John_DeKock

    you can get the information of the owner via the Power BI API. See the documentation here:

    Admin - Reports GetReportUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

    The field "reportUserAccessRight" should be the one where you take the "Owner".

     

    Note: You need Admin API access to retrieve contact info for all reports across the tenant.

     

    Best regards!

    PS: If you find this post helpful consider leaving kudos or mark it as solution

     

  • Hi John_DeKock ,

     

    The concept of a "report contact" is often tied to the person who published the report or a designated support contact set in the report's settings in the UI. This information is not directly exposed through the primary report metadata API. 

     

    We pull Power BI activity details weekly via the Activity Events API and do a bulk insert into a SQL database. On top of that, we’ve built a report showing report developers and workspace admins for easier management.

     

    The inferred “Report Contact” is usually based on the PublishedReport activity — the user who originally published the report. You can also consider workspace admins if no clear publisher exists.

     

    https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events

     

    You need access to admin API's to pull the data.

     

    Thanks,

    Sai Teja 

    • John_DeKock's avatar
      John_DeKock
      Helper I

      Yeah exactly! I have also been looking for that and couldnt find it and no one seems to be able to assist. Some people even saying that the "Contact" field is not available to pull.

  • Hi John_DeKock ,


    Thanks for reaching out to Microsoft Fabric Community.

    Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.

     

    Thank you.

  • Hi John_DeKock ,

     

    Just checking in to see if you query is resolved and if any responses were helpful.
    Otherwise, feel free to reach out for further assistance.

     

    Thank you.

  • Hi John_DeKock and durham4 ,

    Thank you for the follow up and for sharing your findings.

     

    To clarify, the Reports REST API, including Get Reports in Group, does not return the Contact field configured in the Service. That property is not currently exposed through Reports APIs, Admin APIs, or Scanner APIs.

     

    If the requirement is specifically to identify who actually created or published a report, the supported approach today is to review the Power BI Activity Log and check the relevant report creation or publish events.

    There is no dedicated REST API property that directly returns the original publisher or the Contact value.

     

    Please reach out for further assistance.
    Thank you.