Automated export to file for Power BI Report

[Dor-Y13]

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? 

[rohit1991 · Accepted solution]

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).

[rohit1991 · Accepted solution]

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).

[Dor-Y13]

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 · Accepted solution]

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.