Power BI Export to PDF in Power Automate Not Working with Premium Per User License – “Not Found” Err

[SystemSolver]

Hi everyone,

I'm trying to export a Power BI report to PDF using Power Automate with a Power BI Premium Per User (PPU) license. I’ve set up the flow in Power Automate with the "Export to File for Power BI Reports" action, selecting the correct workspace and report ID, and specifying PDF as the export format. However, every time I run the flow, I encounter a "Not Found" error.

Here’s what I’ve checked so far:

1. The workspace is assigned to Premium Per User.
2. Export settings are enabled in the Power BI tenant settings.
3. I have access to the workspace and report.

Has anyone encountered this issue or have any ideas on what might be causing the error? Is there any additional configuration required for PPU licenses to enable export functionality in Power Automate?

Thanks in advance for any guidance!

[KiranHosakote]

Hi @SystemSolver 

You are right. This functionality is not supported by the PPU License, and there is no out-of-box solution using Power BI and Power Automate even with Premium / Fabric capacities.

If you are open to third-party solutions, BI Helper https://bihelper.tech will work for you. 

BI Helper is a user-friendly SaaS application that facilitates the automated creation and distribution of filtered PDFs (filtered for each end-user) to internal and external users. It is secure and scalable, and uses just one Power BI Pro / PPU license.

[Anonymous]

Hi @SystemSolver ,

According to the documentation, the capacity needs to be any A1/EM1 - A6/P3 SKU, these are Premium Per Capacity (PPC).

Export and email a report with Power Automate - Prerequisites

There's a workaround, check joeytsui's reply:

Solved: Power Automate: Report requested for export is not... - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[SystemSolver]

To clarify, exporting from Power BI via Power Automate requires Premium Capacity, and a Premium Per User license won’t support this. A possible workaround is subscribing to a PDF and configuring it to be sent via email.

Do you know if there’s any way to send an Excel file with just a Premium Per User license, or would Premium Capacity be required for that?

[Anonymous · Accepted solution]

Hi @SystemSolver ,

I can only find documents that currently support paginated reports and are limited to one export in 5 minutes.

Export paginated reports with Power Automate - Power BI | Microsoft Learn
Export a paginated report for each row in an Excel Online table or SharePoint list - Power BI | Micr...

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[rajendraongole1]

Hi @SystemSolver -The "FeatureNotAvailableError" you’re seeing in Power Automate when using the "Export to File for Power BI Reports" action can have a few potential causes, even with a Power BI Premium Per User (PPU) license. 

Power BI Premium Per User (PPU) license should indeed allow exporting reports to PDF or other formats via Power Automate. However, ensure that Export to File settings are enabled in the Power BI Admin Portal under Tenant settings. You may need admin access to verify this.

Power Automate may require additional permissions to access the Power BI workspace and report. In Power Automate, check the Connections to Power BI and ensure they are active and properly authorized.

Export Power BI embedded analytics reports API - Power BI | Microsoft Learn

my view,  try re-creating the Power Automate flow or testing with a simpler report to isolate any potential issues related to report complexity. Hope this helps.

[SystemSolver]

Thank you for the detailed suggestions! I’ve already tried these steps and ensured the Export to File settings are enabled in the Power BI Admin Portal. However, I believe the issue may be related to my license. Specifically, I suspect that certain features required for this functionality might not be fully supported under the Premium Per User license.

If you have any additional insights or suggestions, I’d greatly appreciate it!