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...
SwayamSinha
Microsoft Employee
Microsoft EmployeeIt 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 ?