API to get Power BI metadta

Kumar, Arun 336 Reputation points
2024-02-19T04:15:41.84+00:00

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

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

and pass datasetid in below API to get the connection details

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?

https://api.powerbi.com/v1.0/myorg/reports
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,244 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 34,426 Reputation points MVP
    2024-02-19T04:18:57.23+00:00
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.