Fill PowerPoint template with Power BI visuals

[musicjonny]

Hello everybody, 

I have an Power BI report which is published in the Power BI service. The report has multiple pages that are connected with each other to show different aspects based on the same filters. 

There should be a predefined PowerPoint presentation which conforms with the corporate design guidelines and which should summarize the results based on the choices of the report users. The visuals and structure of the presentation would always be the same but the content would change. Users of the report should be able to fill this presentation based on the currently selected filters. The visuals do not have to be dynamic or refresh in some way. 

I have looked for a solution and I am aware of the Power BI integration in PowerPoint. But this solutions won't fit our usecase. Especially as there would be a Power BI branding instead of the own CI and that the report would not fill the whole PowerPoint page. 

Is there any solution that would fit my requirements? Power Automate or other services would be acceptable if necessary. 

Thank you in advance 🙂 

[Anonymous · Accepted solution]

Hi @musicjonny ,

In the Power BI Service, open the report to the page you want to insert. Choose Export, select PowerPoint, and then select Embed live data. This will allow you to include your changes (Embed report with the data filters you selected).

Once you have imported your visuals from your Power BI report to your PowerPoint presentation, you can edit your slicer’s value by selecting it in the dropdown menu or typing it. Select the visuals you want to update and click on the Apply & Update button.

After exporting the Power BI data to PowerPoint, you can manually adjust the visuals to fit your corporate design guidelines. This would involve resizing and repositioning the visuals, changing colors, fonts, etc., to match your corporate branding.

You may also try Power BI template apps. They are pre-built Power BI dashboards and reports, configured to connect to specific data sources. They allow Power BI partners to build Power BI apps with little or no coding, and deploy them to any Power BI customer. If you can create Power BI reports and dashboards, you can become a template app builder and build and package analytical content into an app.

Create template apps in Power BI - Power BI | Microsoft Learn

Best regards.
Community Support Team_Caitlyn

[musicjonny]

The first part of your provided solution does not fit the question I asked. The users should not insert each needed visual of the Power BI report after applying the filter by themselves. I know about this solution but this would mean, that we would create a copy each time the Powerpoint presentation would be needed. As this happens many times and there are multiple pages, this solution is not feasible. 

Is there a solution where the users chooses the correct filters / slicers and the visuals / content in a preconfigured PowerPoint presentation would be updated. 

And I do not understand who a template app could help me with this PowerPoint problematic. Can you please remove the "solved" from your solution? 

Kind regards