Building an inventory report for report contact lookup

[millsmi]

We run Self Service Power BI and often, our Service Desk receives a call from someone who wants access to a Power BI report but are unsure who they should contact to request access.  These requests end up coming to the technology team responsible for the global Power BI tenant.

We would like to build an inventory report and share it to all employee's in the company (35,000) so the service desk may redirect people to it.  The business user can then look up the report by name and find out who the support contacts are.

We have tried getting this information via Powershell, but even a Global Service Admin is unable to pull the contact & report name information if we do not have access to the workspace.

Does anyone know of a way, we can pull this information for all content?  Are there any tools that can be leveraged?  

[collinq]

Hi @millsmi ,

You should be able to get that information from the API. https://learn.microsoft.com/en-us/rest/api/power-bi/    However, whenever a person tries to get to a workspace that they don't have access to and they click on the "Request Access" option, that request goes to the "Contact List" in the Workspace (which defaults to the Workspace Admins).

[millsmi]

This proposed solution won't work for us, we have thousands of workspaces and even though we do have the ability to grant ourselves access to workspace, we don't unless there is a legitimate reason.  Everything is audited and we are in a regulated industry.  We don't own the reports or the data (which could being highly sensitive) contained in workspaces.  It is also impractical to grant ourselves access or request access to thousands of workspaces.

There should be some way, we can identify the report contacts without actually granting access to the workspaces.

[collinq]

Hi @millsmi ,

I don't believe that there is any way to do this.  Perhaps turn in a ticket to Microsoft and see if there is any background way?  MAYBE, there is some way to do it in the O365 logging????   Either way, please let us know here if you find out a way to do it other than sugggested above!

[millsmi]

Hey Collinq,

Yeah, we have a support case already in with Microsoft, not getting very far with them unfortunately.  I think I will need to reach out to my CSAM to invoke a request to set up a Teams meeting with the appropriate PG.