Forum Discussion
Resolver IExport portrait report to portrait PowerPoint slides
Thanks for the clarification user01
You can combine Power Automate and VBA to fully automate the process. First, use Power Automate’s “Export to File for Power BI Reports” action to export your report pages as portrait images (or as a PowerPoint file) using a scheduled or on-demand flow. Next, create a PowerPoint template with portrait (letter-sized) slides, and then use a VBA script within PowerPoint to automatically loop through the exported images—adding a new slide for each one and resizing it to eliminate white space.https://stackoverflow.com/questions/61570841/export-an-image-from-powerpoint
https://www.techrepublic.com/article/use-vba-to-insert-a-picture-file-onto-a-powerpoint-slide
Hi user01 , thank you for reaching out to the Microsoft Fabric Community Forum.
Thank you nilendraFabric , for your answer.
There is no built-in way in Power BI to automatically export a portrait report into a portrait PowerPoint slide without additional steps. Power BI’s "Export to PowerPoint" feature defaults to landscape slides, and exporting as an image also places the portrait report on a landscape slide with white space.
To automate this in one step, you would need a custom solution using Power Automate and a predefined portrait PowerPoint template, but this adds complexity and may require additional licensing.
Regarding "Export to File for Power BI Reports" in Power Automate:- If you export as an image, it remains static.
- If you export as a PowerPoint file, the report content will still be static images, not editable text boxes. Power BI does not currently support exporting fully editable objects into PowerPoint.
If eliminating all extra steps is the top priority, there is no native way to achieve this within Power BI today.
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Super UserThanks for the clarification user01
You can combine Power Automate and VBA to fully automate the process. First, use Power Automate’s “Export to File for Power BI Reports” action to export your report pages as portrait images (or as a PowerPoint file) using a scheduled or on-demand flow. Next, create a PowerPoint template with portrait (letter-sized) slides, and then use a VBA script within PowerPoint to automatically loop through the exported images—adding a new slide for each one and resizing it to eliminate white space.
https://stackoverflow.com/questions/61570841/export-an-image-from-powerpoint
https://www.techrepublic.com/article/use-vba-to-insert-a-picture-file-onto-a-powerpoint-slide
Resolver InilendraFabricThanks for the response. I am not that familiar with Power Automate, but I think I get the idea. I think is this an interesting solution. But we want fewer steps because this is self-service. The users come to the app and downloads the Power BI report as needed.
So Power Automate will first export a portrait image on a landscape slide? The use the a seperate portrait template PowerPoint with a VBA script to import the portrait images?
Do you know if Power Automate require additional licenses? Currently our users can use our app without licenses because the app is on a premium space.
It does not sound like you can simplified this to one step, right?
Side note/question: You said:
Power Automate’s “Export to File for Power BI Reports” action to export your report pages as portrait images (or as a PowerPoint file)
If you export as "PowerPoint file", it will not be a static image? There will be objects, like editable text boxes? So if you want to tweak the wording of text, you can edit it easily?
v-hashadapuCommunity Support
Hi user01 , thank you for reaching out to the Microsoft Fabric Community Forum.
Thank you nilendraFabric , for your answer.
There is no built-in way in Power BI to automatically export a portrait report into a portrait PowerPoint slide without additional steps. Power BI’s "Export to PowerPoint" feature defaults to landscape slides, and exporting as an image also places the portrait report on a landscape slide with white space.
To automate this in one step, you would need a custom solution using Power Automate and a predefined portrait PowerPoint template, but this adds complexity and may require additional licensing.
Regarding "Export to File for Power BI Reports" in Power Automate:- If you export as an image, it remains static.
- If you export as a PowerPoint file, the report content will still be static images, not editable text boxes. Power BI does not currently support exporting fully editable objects into PowerPoint.
If eliminating all extra steps is the top priority, there is no native way to achieve this within Power BI today.
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.