Forum Discussion

ChrisAZ's avatar
ChrisAZ
Icon for Helper V rankHelper V
1 year ago
Solved

Trying to export a specific PowerBI report via email (using Power Automate)

So I built a Power Automate flow, and I am able to get it to the point where I can get it to send emails based on my list, but it is sending the same unfiltered version to everyone. I am passing it a...
Need Help
  • v-hashadapu's avatar
    v-hashadapu
    1 year ago

    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

KiranHosakote's avatar
KiranHosakote
Icon for Post Patron rankPost Patron
9 months ago

hi ChrisAZ 

 

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 filtered user-specific PDF and PPTX reports from Power BI and Tableau. Over 200 businesses across the world routinely use BI Helper to share actionable information and insights with their customers, vendors and employees. 

 

BI Helper is secure and scalable and only needs one Power BI Pro / PPU license for the sender.