Power Automate - Export To File for Power BI Reports - Question about settings

[jerryr125]

Hi - I am using Power Automate - Export To File for Power BI Reports - to obtain an image of a visualization.

Question:

As I view the "Code view", I notice there are some parameters.  Is that any parameters to set the image height and width ???

Such as a ExportPayloadPowerBIReport parameter(s) ?

"parameters": {

      "groupid": "7a86dd50-779e-4a6b-984f-54321",

      "reportid": "3c21a3b8-1c7f-4b11-b7b3-123456",

      "ExportPayloadPowerBIReport/format": "PNG",

      "ExportPayloadPowerBIReport/PowerBIReportExportConfiguration/pages": [

        {

          "pageName": "abc12345678",

          "visualName": "efg987654"

        }

      ],

Any assistance would be appreciated - Thanks - Jerry

[SaiTejaTalasila]

Hi @jerryr125 ,

You can refer this post -

https://www.linkedin.com/pulse/distribute-power-bi-report-visuals-through-email-body-ikram-ph-d?utm_...

I hope it will be helpful.

Thanks,

Sai Teja 

[jerryr125]

Hi - This article was a big help - thank you very much !

The issue I am having now is the bottom part of the image is truncating.

Any thoughts on what would cause this issue ? Jerry

[Anonymous]

Hi @jerryr125 ,

Could you provide us with some pictures? Or please tell me what visual you are using and the page size. Currently, the export report action does not support custom page sizes, the current error may be due to the visual relative position resolution error, I recommend that you copy the visual to a new blank page. Then run your flow to see that the new page displays normally.

Best regards,

Mengmeng Li

[lbendlin]

No, it takes the dimension of the visual on the page, and renders the same as in the report.

[jerryr125]

Hi - thanks for the reply - I appreciate it. The visualization is truncating at the bottom though - any reason for that.  The visualization is on a page and is the only visualization on the page.  Its about 80% of the height of the page as well.

Any thoughts ?