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
if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
