Export Power BI Report and embed as image in the body of email using Power Automate/Logic apps

[Rajesh1093]

Please follow below steps to Export PowerBI Report as png image and embed it in the body section of the email.  Login to Power Automate or Logic apps in azure to perform the following

1. Create a flow as below in power automate and I have used "When a new email arrives" as a trigger for the next step.

2. Export to file for Power BI Reports:

Select the respective workspace, report and export format. In this case we need to select export format as PNG and the page name should be the report section of the page in the PowerBI service and it can be retrieved in PowerBI service.

3. Initialize a variable :

Add this action to your flow, and give any name for the variable and choose "String" as type. Follow the below steps for the value part

3.1- Type "<img src="data&colon;image/png;base64, " alt="GG" />" in the value section.

3.2- Place your cursor between "base64," and " " " in the value section and then click Expression and type ".$content". 

3.3 - Now click dynamic content and move your cursor before .$content and select file content( output from step 2) and click ok , it will be as below. 

3.4- Content will be updated in the value section as below

4. Select Send an email action to send email , and in the body section click on add dynamic content and add the variable which was created in step 3 as below

5. PowerBI Report image will be embedded in body section of the email as below.

Happy to help and happy automating 🙂 

[SWiL]

My report URL doesn't have a ReportSectionxxx included. It follows this format:
https://app.powerbi.com/groups/xxxxxxx-xxxx-xxx/reports/xxxxxxxxx/xxxxxx?experience=power-bi&clientS... 

How can I find the pagename from this?

[ljkeefe]

@SWiL The page name are all the characters in the URL AFTER the last "/". If you have multiple tabs in your BI report, each tab will have a different page name. I hope this helps.

[JD09]

Hi, @Rajesh1093 ,
I have tried, the same scenario,
I am receiving Email without Image.
Can you please help.

Thank you!!

[SaiTejaTalasila]

Hi @Rajesh1093 ,

You can check power bi embedded playground.

https://playground.powerbi.com/en-us/embedded-demo

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

I hope it helps.

Thanks,

Sai Teja 

[ljkeefe]

You have to follow his steps in Step 3 exactly. When I first did it, it was the "$content" that was giving me issues. 

[lbendlin]

what's the image size?

[JD09]

Hi @lbendlin ,
I have not provided any image size.

Thank Youu!

[lbendlin]

Base64 Strings are limited to 32k characters.

[JD09]

Hi @lbendlin 
Thanks!!

Solution worked for Small Images😊.
The image I was sharing to Outlook was too Large.

[bakason]

Hi @Rajesh1093,

I followed the solution you provided, but instead of a png image, I keep getting a long display of random symbols. I assumed this had something to do with the base64 conversion, so I tried with and without that, but still received the same result. Any ideas on how to solve this?

[yashwant101]

Hi @Rajesh1093,

I used the solution that you have provided. Only one problem: The image is not showing. It is coming like this:

Your help is highly appreciated.

[ljkeefe]

I'm getting the same thing. I've followed these steps at least 3 times. @Rajesh1093 any suggestions?

[ljkeefe]

Nevermind, I found my error; it was with this: Type "<img src="data&colon;image/png;base64, " alt="GG" />" in the value section.

I had a ";" after data not ":", now it works perfectly along with the sizing solution someone provided somewhere in this post.

[Rajesh1093]

@yashwant101 , is your export format of PBI report is PNG and your variable initialization is png format as in section 2 and 3.1 then it should work fine. 

[max351]

Hello, I have the same behaviour though everything seems fine (section 2 and 3.1 set you mentioned).

[Anonymous]

I used a similar solution, the problem I have now is that the image is too big and gets cropped. Any ideas on how to resize the image size in the email body?

[Rajesh1093]

Hi @Anonymous ,

Can you try resizing your image using the below parameter, and it should be added in the section 3.1 

<img src="data&colon;image/jpg;base64, <base64 output" width="100" height="100" alt="demo image" />

[lbendlin]

Note that there is a string length limit on Base64 strings. Your approach will only work for very small attachments.

[mukul_goswami]

is there any solution for this because i am taking one matrix visual and it is getting cropped

[lbendlin]

In Power BI you can concatenate the Base64 encodings for larger images (Power BI has a 32677 character limit for strings). I am not aware of a way to do the same in Power Automate where the string limit is allegedly 131072.