Embed PowerBI report snapshot in mail body through Power Automate

[raj_indulkar]

Want to embed the snapshot of Power BI report as PNG in email body through Power Automate.

eg:- If my Power BI report has 3 pages so i need all 3 pages embedded in email body.

I am using "export to file for powerbi report" as connector to export the file in PNG format and then storing it in Onedrive,but it shows can't preview this file.

It is working for PDF & PPTX format but not for PNG.What is the work around anyhelp would be really appreciated.

Thanks

[v-prasare]

Hi @raj_indulkar 

Thanks for sharing the workaround that worked for you, this will help other users who may face similar issues.
If you have any additional questions, feel free to let us know. Happy to help!

@xifeng_L, @mh2587, Thanks for your prompt response

thanks,

prashanth

[xifeng_L]

Hi @raj_indulkar 

After exporting the PowerBI report as a PNG image, it needs to be converted to base64 format and then embedded into the email body using an HTML img tag.

As shown in the figure below:

concat('data:image/png;base64,',outputs('Export_To_File_for_Power_BI_Reports')?['body']?['$content'])

<img src="@{outputs('Base64Img')}" width="1280" height="720"><br>

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[raj_indulkar]

Thank you for the solution,but i tried this under advanced parameter>>pages>> page name (i:e pageid get this  from URL part between (/  and ?) and it worked for me

[mh2587]

The Power BI Export API returns:

PDF/PPTX single file (easy to attach/embed)

When exporting PNG, the output is actually:

A zip-like binary stream OR

Multiple file parts (not directly previewable in OneDrive)

That’s why:

OneDrive says can’t preview this file

Email embedding fails

So you need:

3 separate PNGs (one per page)

Convert them to Base64

Inject into HTML email body

[raj_indulkar]

Thank you for the solution,but i tried this under advanced parameter>>pages>> page name (i:e pageid get this  from URL part between (/  and ?) and it worked for me