Forum Discussion
"Export To File for Power BI Reports" - Getting NotFound and FeatureNotAvailableError
- 1 year ago
Hi JohanClaesson Currently, the Power Automate 'Export to File for Power BI Reports' feature is only available to users with a Power BI Premium capacity license (which requires at least one Premium workspace). It is not supported for users with a Premium Per User (PPU) license.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export#prerequisites - 1 year ago
Thanks for providing such a detailed breakdown of your setup and the steps you've already taken it's clear you've done a thorough job troubleshooting this issue. Based on the symptoms you're describing specifically the "NotFound" and "FeatureNotAvailableError" messages it seems likely this could be related to known limitations of the Export to File for Power BI Reports action when using Premium Per User (PPU) workspaces.
While PPU supports many features of Power BI, the export API sometimes enforces stricter licensing requirements, especially if the tenant settings or capacity assignment isn't fully aligned. One thing you might want to double-check is whether the Export to File API feature is enabled in the Power BI admin portal for your tenant.
Additionally, make sure that the workspace is not only marked as PPU but also fully assigned to a PPU capacity, as certain backend processes may still rely on capacity association. If everything appears correct and the issue persists, it might be worth opening a support ticket with Microsoft, as this could be an edge case or a backend configuration issue. You're definitely not alone others have run into similar issues with the API on PPU setups.
We had the same problems with the Export to File API. The Microsoft solution is a Premium / Fabric capacity with assigned workspaces.
If your use case is report bursting and if you are open to third-party solutions, take a look at BI Helper https://bihelper.tech or at the Microsoft AppSource store Business Apps – Microsoft AppSource.
BI Helper is a browser-based application which automates the creation and distribution of user-specific PDF and PPTX reports from Power BI and Tableau. Over 200 businesses across the world routinely use BI Helper to share reports with their customers, vendors and employees.
BI Helper is secure and scalable and only needs one Power BI Pro / PPU license for the sender.