Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I have a couple of reports that are letter sized: Canvas Setting > Type > Letter.
When I go to our app online and do Export > Export as image, the report is exported to static portait images on landscape PowerPoint slides. Is there a way to export portrait images on portrait/letter sized Powerpoint slides automatically?
I am aware we can resize the image or resize the slide in PowerPoint. I am also aware that Export to PDF > Export to PowerPoint is a good/superior workaround. But we want to elimnate any additional steps because of the volume of reports and users. The idea is self-service. So we prefer a simple solution as our users want fewer steps and we assume they are not technologically savvy.
Current result (without red X): Portrait image on landscape slide, big white spaces on sides
Desired result: Automatic portrait image, portrait slide, no white space
Hi @user01, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Hi @user01, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Hi @user01, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Hello @user01
Not sure if I understand the question properly.
but here is what I understood, you have letter size reports. When you exported them , it is exported as portrait.
now to you want to put it properly in PowerPoint .
if yes here is the solution
Change PowerPoint Slide Orientation to Portrait
By default, PowerPoint uses landscape orientation, but you can change it to portrait:
• Open PowerPoint.
• Go to the Design tab.
• Click Slide Size and select Custom Slide Size.
• Under the “Orientation” section, choose Portrait for slides and click OK. You may be prompted to choose between “Maximize” or “Ensure Fit”—select based on your preference for content scaling.
please accept the answer if this is helpful
@nilendraFabricThanks for the response. You have the right idea. I attached an image to the original question.
I am aware of resizing the slide or image. We want to eliminate this step. We want to export the portait image automatically to a portrait slide.
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
@nilendraFabricThanks 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?
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 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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
48 | |
29 | |
21 | |
19 | |
13 |