Autogenerate Power Point with Power BI and Power Automate

[Ingo_BI]

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 Premium Capacity. 

The requirements for the PPTs are: 

- Package 1: 3 different PPTs (with the same structure) but filtered based on company and automatically sent to company manager via email.

- Package 2: One consolidated version for the parent company where the 3 different P&L for the companies should be included aswell as a consolidated P&L. Should be automatically sent via email. 

So in short the different questions are: 

- Is it possible to loop through a list of managers and send the right PPT to the right recipent? 

- Is it possible to loop through a slicer/filter (with 3 companies) and create 1 slide per P&L in one PPT? 

We have already done this for another client in QlikView via Nprinting (cost for Nprinting license: 9 kUSD/year) and the same can also be done in Qlik Sense (for a extra license cost of 8 kUSD/year). 

Can it be done in Power BI/Power Automate without a Premium Capacity for 60 kUSD/year? And in that case, how? 

[Anonymous]

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]

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; Manager@CompanyA.com
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.