Connect workspace data to excel

[MikolajSikorsk]

Hi,

I want to export to excel/sharepoint list all informations from existing Organisational Power BI Workspaces.
The general porpouse of this is to have better control under all existing reports ( is refreshed ? who is owner e.g ) 

Is any way to do this ? 

[SwayamSinha]

It might be possible by using Power BI Admin REST APIs. You need the required admin level access to execute the same. Also if your organisation is huge , all that information might not fit in a single API call. 

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

[MikolajSikorsk]

I have Admin Permissions on the organisational level, I also found command good for my solution. 
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/widely-shared-artifacts-published-to-web
But when i try to connect it via web connection, it asking for key. 
Do you know where i can find it ? 

[MikolajSikorsk]

2 or even 10 clicks is also good option, 
I mean, im looking for any solution. 

[ribisht17]

There are a few in-built reports like this 

 Monitor usage and performance - Training | Microsoft Learn

Regards,

Ritesh

[ribisht17]

Hi @MikolajSikorsk 

If you mean all information about workspace with one click, then NO

Regards,

Ritesh