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
Community SupportHi ChrisAZ , Thank you for reaching out to the Microsoft Community Forum.
Your flow is built right, but the reason everyone’s getting the same unfiltered report is that the Export to File for Power BI Reports action will ignore your filter JSON unless three things are true: the report is in a Premium or PPU workspace, your JSON filter matches the exact dataset schema names (not display names and case-sensitive) and the report is saved in a clean state with no preset filters that override the API.
In your flow, you need to drop the filter JSON into the Report level filters (JSON) box of the Export step, looping through your Google Sheet and dynamically substituting the driver name for each row. That way, each iteration generates a uniquely filtered export tied to the right email. If your report is in Premium and your field names match, this will work exactly as intended.
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.
- v-hashadapu
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
- 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.