Forum Discussion
Helper VTrying to export a specific PowerBI report via email (using Power Automate)
Hi ChrisAZ , Thank you for reaching out to the Microsoft Community Forum.
A Premium Per User (PPU) license alone will not keep your flow working the way it does under the Fabric trial. The Export to File for Power BI Reports action only works if the report’s workspace is on a dedicated capacity (Premium or Fabric). PPU gives you per-user access to premium features, but it doesn’t place the workspace on dedicated capacity, so once your Fabric trial ends, those filtered exports will fail. If you want the automation to keep running, you’ll need to assign the workspace to a Premium/Fabric capacity.
Power BI Premium Per User - Microsoft Fabric | Microsoft Learn
Export Power BI embedded analytics reports API - Power BI | Microsoft Learn
Helper VI was able to get this resolved under another thread where I posed a video of my process and there were a few minor syntax updates needed. I am a bit confused on whether a Premium PPU license works for this as I have seen and heard from some that it will work fine for what we are trying to do, and others pointing to documentation stating it requires a Fabric capacity to do this. Can you confirm? To add, it works right now because we are on a Trial of Fabric, but wondering if we wind up purchasing a Premium PPU license, will that still work.
Community SupportHi ChrisAZ , Thank you for reaching out to the Microsoft Community Forum.
A Premium Per User (PPU) license alone will not keep your flow working the way it does under the Fabric trial. The Export to File for Power BI Reports action only works if the report’s workspace is on a dedicated capacity (Premium or Fabric). PPU gives you per-user access to premium features, but it doesn’t place the workspace on dedicated capacity, so once your Fabric trial ends, those filtered exports will fail. If you want the automation to keep running, you’ll need to assign the workspace to a Premium/Fabric capacity.
Power BI Premium Per User - Microsoft Fabric | Microsoft Learn
Export Power BI embedded analytics reports API - Power BI | Microsoft Learn
- ChrisAZ
Thanks for the confirmation. We have decided to go with a 3rd party tool to do this that is actually less complicated and will be far cheaper than paying for a full Fabric capacity for what we need. Microsoft should really come up with more options for cases such as this where we do not need a giant bill for a small amount of use. The tool is called BI Helper.