PowerBI Export RestAPI failing for 500MB file

Hi BhumitraSharma,

I hope you are doing well today☺️❤️

This issue known as 4 minute timeout limitation, It is a hard limit on the service side and for large files (especially 500MB+) the export process often exceeds this limit. So Here is Some Approaches:

First Approach: Use Async Pattern with Export to File (its specifically designed for large exports)

• The Export API has a synchronous limit Instead of this use the asynchronous Export to File API which is designed for large reports:

# Step 1: Start export job
start_response = requests.post(
    f"https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/reports/{report_id}/ExportTo",
    headers={"Authorization": f"Bearer {access_token}"},
    json={
        "format": "PBIX",
        "powerBIReportConfiguration": {
            "includeReportMetadata": True
        }
    }
)

# Get the export job ID
export_id = start_response.json()["id"]

# Step 2: Poll for status
while True:
    status_response = requests.get(
        f"https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/reports/{report_id}/exports/{export_id}",
        headers={"Authorization": f"Bearer {access_token}"}
    )
    
    status = status_response.json()["status"]
    
    if status == "Succeeded":
        # Step 3: Download the file
        result_url = status_response.json()["resourceLocation"]
        download_response = requests.get(result_url)
        with open("report.pbix", "wb") as f:
            f.write(download_response.content)
        break
    elif status in ["Failed", "TimedOut"]:
        raise Exception(f"Export failed: {status_response.json()}")
    else:
        time.sleep(5)  # Wait before polling again

Second Approach: Increase Timeout and Handle Retries

If you must use the synchronous Export API you can just increase the timeout:

import requests
import time
from tenacity import retry, stop_after_attempt, wait_exponential, retry_if_exception_type

@retry(
    stop=stop_after_attempt(3),
    wait=wait_exponential(multiplier=1, min=4, max=10),
    retry=retry_if_exception_type(requests.exceptions.Timeout)
)
def export_large_report(workspace_id, report_id, access_token):
    url = f"https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/reports/{report_id}/Export"
    
    headers = {
        "Authorization": f"Bearer {access_token}",
        "Accept": "application/octet-stream"
    }
    
    params = {
        "format": "PBIX",
        "preferClientRouting": "true"
    }
    
    # Use streaming to handle large files
    with requests.get(url, headers=headers, params=params, stream=True, timeout=300) as response:
        response.raise_for_status()
        
        with open("report.pbix", "wb") as f:
            for chunk in response.iter_content(chunk_size=8192):
                f.write(chunk)
    
    return True

Bonus Solution: PowerShell 

If Python continues to have issues, use PowerShell which handles large file transfers better:

$headers = @{
    "Authorization" = "Bearer $accessToken"
    "Accept" = "application/octet-stream"
}

$params = @{
    "format" = "PBIX"
    "preferClientRouting" = "true"
}

Invoke-RestMethod -Uri $url -Headers $headers -Method Get -Body $params `
    -OutFile "report.pbix" -TimeoutSec 600