Forum Discussion

Ingo_BI's avatar
Ingo_BI
Frequent Visitor
2 years ago

Autogenerate Power Point with Power BI and Power Automate

Hi,    I work as a consultant within BI.    A potential customer wants to evaluate Power BI:s capacity to autogenerate Power Points based on Power BI reports. The client does not want to pay for ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ingo_BI ,

If I understand correctly, the issue is that you want to autogenerate Power Point based on Power BI reports without paying for Premium capacity. Please try the following methods and check if they can solve your problem:

1.It is possible to loop through a list of managers and send the right PPT to the recipient. You can use Power Automate to send reports to specific emails automatically.

 Create a Power Automate visual for Power BI (preview) - Power BI | Microsoft Learn

 

2.It is possible to loop through a slicer and create one slide per in one ppt. You may need to create separate reports within a report that are pre-filtered for each company and then automate the export of these individual report as separate slides.

 

3.The cost for Power BI Pro license is less than the Power BI Premium capacity.

 

4.The current pricing for Power BI Pro is available here.

Pricing & Product Comparison | Microsoft Power BI

 

Looking forward to your reply.

Best Regards,

Wisdom Wu

  • Ingo_BI's avatar
    Ingo_BI
    Frequent Visitor
    2 years ago

    Hi, 

     

    Thanks for your attempt to answer me! 

     

    I am well aware of 3. and 4. in your answer. 

     

    I still don't understand whether I can make this flow to work without having the Premium per Capacity license. I tried to setup this flow:

    1. Create a report in Desktop and publish to a Premium per User (please note User and NOT Capacity)  workspace in Service . The report is structured in a way to work for Package 1 in my initial post. 

    2. Created an Excel file with 2 columns: Company and ManagerEmail. Example: CompanyA; [email protected]
    3. Created two steps within a "For each" that should create a PPTX-file AND send it to the correct manager based on the Excel file. 

     

    However when testing this I get an error message regarding "Reserved capacity". After reading about it I get the feeling that the problem is that I don't have a Premium per CAPACITY license, which costs 5kUSD/month.