Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

PowerBi API Threshold limit error in Python

I have a requirement to fetch all the Reports in PowerBi and their respective data source details(like, connection string, source query/table used etc.) using Synapse Pipeline/Notebook(pyspark). I have developed a Pyspark(Synapse notebook) as follows.

  1. Fetch all the reports data using Powerbi admin API
    1. API used :
  2. Collect the report data into a list
  3. Loop through the list and in the loop I used following API to fetch datasource details.
    1. API Used :'+ datasetId +'/datasources'
  4. capture the required details and write to a blob storage

The notebook ran fine without any issues for a week. And after that, I'm getting the error "Threshold limit exceeded, please try after XYZ seconds" in the step-3 (where I'm looping through all the available list of reports and fetching their respective connection details). Could you please help me in fixing this issue.

Super User
Super User

you are likely hitting a 429.  Introduce a delay in your loop to avoid that.  And think about using incremental refresh.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors