I was trying to use Export-PowerBIReport or Invoke-PowerBIRestMethod to export a Power BI Report (~25MB in size) and I'm getting a 500 internal server error. After reviewing the API documentation (https://docs.microsoft.com/en-us/rest/api/power-bi/reports/export-report-in-group) I see this note:
"As a workaround for fixing timeout issues, you can set preferClientRouting to true.
Large files are downloaded to a temporary blob. Their URL is returned in the response and stored in the locally downloaded PBIX file."
When I add that (https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/export?preferClientRouting=true) I get a 403 Forbidden. I'm the Power BI admin on the tenant and I'm an admin on the workspace. The workspace is also not in a large dataset format at the moment.
I've tried this on 3 different tenants, and I am only able to replicate the 403 error on Power BI instances on East 2. On East 2, the workspace can be Pro, Premium Per User, or Premium and I get the same result (403). On a sovereign tenant the export api call works without issue.
What I have discovered is the redirect URL provided by the API in the 307 response is inaccessible. However, the URL that works via the manual method is at the same host (ex. https://wabi-us-east2-b-primary-redirect.analysis.windows.net) but at a different endpoint “export/v201606/reports/{Report ID}/pbix”. This appears to be a bug on a commericial tenant.
8 Comments
- v-chuncz-msft
Community Support
Status changed:NewtoInvestigating - kerski
Advocate II
v-chuncz-msft I did, but there appears to be something wrong with the redirect in East 2. I verified this is not a problem in a sovereign tenant. More details on my findings are here: https://www.kerski.tech/bringing-dataops-to-power-bi-part12/
- kerski
Advocate II
It looks like as of Nov. 16th, 2021 the issue does not occur on East 2.
- v-chuncz-msft
Community Support
- patrickeadsNew Member
I'm still seeing the same issue for files >100mb as well.
- gwagnerNew Member
Is there any news about this error? Do you know from what .pbix size it happens?
- fariayakhanRegular Visitor