Report Catalog for PowerBI

[lmessy]

Hi, i have a question which i need assistance with. In SSRS we have a report currently called the report catalog, what it does is give the user a complete list of reports on our SSRS portal along with a description of the report, a link to the report and how often the report is used. As we are now migrating our SSRS reports to Power BI, we find ourselves in need of replecating this report or finding a means to have a catalog of sorts which will list all reports in all workspaces as well as with a description of each report. Can anyone please assist a newbie with a way of making this possible?

[ppm1]

Please see if the new admin monitoring experience gets you what you need.

Admin Monitoring for Tenant Admins | Microsoft Power BI Blog | Microsoft Power BI

Pat

[Sahir_Maharaj]

Hello @lmessy,

1. Use the Power BI REST API to retrieve the list of workspaces and reports. You can make the following API calls:

   • Get all workspaces: /groups
   • Get all reports within a workspace: /groups/{groupId}/reports

2. For each report, use the Power BI REST API to retrieve additional details, including the description. You can make the following API call for each report:

   • Get report details: /groups/{groupId}/reports/{reportId}

3. Merge the workspace and report details along with their descriptions in a format that suits your needs (e.g., a table or a CSV file). You can use your preferred programming language (e.g., Python, C#, PowerShell) to write a script that retrieves the data and formats it accordingly.

4. Set up a process or schedule the script to run periodically to keep the catalog up to date. This will ensure that any changes to workspaces or reports are reflected in the catalog.

5. Once the catalog is generated, you can publish it to a web page, SharePoint, or any other suitable platform. This will provide users with easy access to the catalog and enable them to browse the reports along with their descriptions.

Should you require further details or assistance please do not hesitate to reach out to me.