Forum Discussion
Automated export to file for Power BI Report
Hello,
I am encountering an issue when attempting to use the "Export to File for Power BI Reports" action in Power Automate.
Despite the report being published to a workspace assigned to Premium Per User (PPU), and my account having an active PPU license, the export action fails with the following
{
"statusCode": 404,
"headers": {
"Cache-Control": "no-store, must-revalidate, no-cache",
"Pragma": "no-cache",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Frame-Options": "DENY",
"X-Content-Type-Options": "nosniff",
"RequestId": "f1ffad9a-1128-4d3f-9f1d-8bc1631859db",
"Access-Control-Expose-Headers": "RequestId",
"x-ms-client-region": "europe",
"x-ms-flavor": "Production",
"X-Ms-Workflow-Resourcegroup-Name": "selfhostingresourcegroup",
"x-ms-workflow-subscription-id": "Default-86812322-2ad9-4b97-9a63-0f8ae0b58566",
"x-ms-environment-id": "default-86812322-2ad9-4b97-9a63-0f8ae0b58566",
"x-ms-tenant-id": "86812322-2ad9-4b97-9a63-0f8ae0b58566",
"x-ms-dlp-re": "-|-",
"x-ms-dlp-gu": "-|-",
"x-ms-dlp-ef": "-|-/-|-|-",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Thu, 10 Jul 2025 17:30:49 GMT",
"Content-Length": "180",
"Content-Type": "application/json"
},
"body": {
"error": {
"code": "FeatureNotAvailableError",
"pbi.error": {
"code": "FeatureNotAvailableError",
"parameters": {},
"details": []
}
}
}
}
My setup:
I’m using a Power BI Pro + Premium Per User (PPU) licensed account
The report is published to a workspace that is explicitly set as Premium per user
I selected the report from the dropdown in Power Automate (no manual IDs used).
I recreated the connection in Power Automate using the correct user
Even a simple test report with one blank page fails to export
The workspace’s Premium settings show "Power BI Premium per User"
Could you please assist me?
That may be caused since i have just upgraded to PPU?
Maybe some additional settings needs to be adjusted?
Hi Dor-Y13 ,
This error usually happens because the "Export to File for Power BI Reports" action in Power Automate only works with workspaces assigned to Premium capacity (not Premium Per User - PPU). Even if you and your workspace both have PPU licenses, the export action is not supported for PPU workspaces—it requires a workspace on a dedicated Premium capacity (SKU like P1, P2, etc.), not just PPU.
Summary/Direct Answer:
-
PPU (Premium Per User) workspaces are not supported for Export to File via Power Automate.
-
This limitation is by design from Microsoft.
-
To use the export action, the report must be in a workspace backed by Premium capacity (not just PPU).
-
Your licenses and setup are correct, but this feature is not available for PPU, which is why you see FeatureNotAvailableError and a 404 error.
What you can do:
-
Move the report to a workspace assigned to a full Premium capacity (if available).
-
Or, use other export methods supported by PPU (like exporting manually in the Power BI Service).
-
Hi Dor-Y13 ,
Manual export in Power BI means opening your report in the Power BI Service and using File > Export > PDF or Export > PowerPoint to save the report. This must be done by hand—there’s no scheduling.
Subscriptions let you receive email snapshots of the report on a schedule. You can set this up by clicking the Subscribe button in Power BI Service.
Details: Subscribe to reports and dashboards in Power BI*Note: For automated export to file (via Power Automate), you need a workspace on full Premium capacity, not just PPU.
3 Replies
rohit1991Super User
Hi Dor-Y13 ,
This error usually happens because the "Export to File for Power BI Reports" action in Power Automate only works with workspaces assigned to Premium capacity (not Premium Per User - PPU). Even if you and your workspace both have PPU licenses, the export action is not supported for PPU workspaces—it requires a workspace on a dedicated Premium capacity (SKU like P1, P2, etc.), not just PPU.
Summary/Direct Answer:
-
PPU (Premium Per User) workspaces are not supported for Export to File via Power Automate.
-
This limitation is by design from Microsoft.
-
To use the export action, the report must be in a workspace backed by Premium capacity (not just PPU).
-
Your licenses and setup are correct, but this feature is not available for PPU, which is why you see FeatureNotAvailableError and a 404 error.
What you can do:
-
Move the report to a workspace assigned to a full Premium capacity (if available).
-
Or, use other export methods supported by PPU (like exporting manually in the Power BI Service).
Thanks a lot for the explanation!
Could you please describe which solution is available in the manually export PBI? so i guess that i can scheduale a subscribe notice for my report and then i dont need the PPU liscense?
Many thanks!
Dor
- rohit1991
Hi Dor-Y13 ,
Manual export in Power BI means opening your report in the Power BI Service and using File > Export > PDF or Export > PowerPoint to save the report. This must be done by hand—there’s no scheduling.
Subscriptions let you receive email snapshots of the report on a schedule. You can set this up by clicking the Subscribe button in Power BI Service.
Details: Subscribe to reports and dashboards in Power BI*Note: For automated export to file (via Power Automate), you need a workspace on full Premium capacity, not just PPU.
-
