Forum Discussion
Connect workspace data to excel
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 ?
5 Replies
If you mean all information about workspace with one click, then NO
Regards,
Ritesh
2 or even 10 clicks is also good option,
I mean, im looking for any solution.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
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 ?
