Get Power BI Metadata like connections, workspace, views used

[arunkumarcg]

Hello all, I have a requirement to get Power BI cloud connections, views it is using, workspace details etc using PySpark notebook from Synapse. Currently i get report details using this API

YAMLCopy

https://api.powerbi.com/v1.0/myorg/admin/reports

and pass datasetid in below API to get the connection details

YAMLCopy

https://api.powerbi.com/v1.0/myorg/admin/datasets/'+ datasetId +'/datasources'

But i am getting error saying "you have reached maximum limit, try again after 3200 seconds'

I tried without admin in the API like below and it's throwing 400 unauthorized error. Any idea how to use API with admin and not having the limitation error? Or how to use below api without admins?Whats the config i need to do in Power BI for below API to work?

YAMLCopy

https://api.powerbi.com/v1.0/myorg/reports

[lbendlin]

Ask your tenant admin to run the audit and scanner api calls for you. They should do that anyway as part of the maintenance.

[arunkumarcg]

We are planning to have it run automatically through a Python script and display the same on dashboard.

[lbendlin]

Sorry to hear that.  Wrong tool, in my opinion. These scripts need to be run daily by the tenant admin and the results stored for eternity  (data disappears from the service after 30 days)