What is the best way to inventory all reports for all workspaces in Power BI Service?

[ELIU]

Hi,

I'd like to understand how I can get an inventory of all reports for all our workspaces without manually jogging down every single report, its workspace, scheduled refresh, times of failed refresh, etc. in an Excel schedule. Is there a better way and automatic way to do that so we can get a report of such inventory every day which reflects the most current state of the inventory?

Thanks

[v-shamiliv]

Hi @ELIU 
Thank you for reaching out microsoft fabric community forum.
I wanted to check if you had the opportunity to review the information provided @collinq  and @Deku . Please feel free to reach us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Deku]

If you run the scanner API it will list all workspace, reports, semantic models ,tables columns, data sources, user permissions etc

.

[collinq]

Hi @ELIU ,

You can do that quite easily if you use the Rest API.  That can be found here: Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn

You would probably need to be in the Overview section, and the "GET" commands, like "GetAppsAsAdmin"

[ELIU]

@collinq Thank you! I'll give it a try and see how it looks!