Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Rajesh1093
Frequent Visitor

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

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.

Rajesh1093_0-1708678390994.png

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.

Rajesh1093_1-1708678648229.png

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.

Rajesh1093_2-1708678946337.png

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

Rajesh1093_3-1708678977988.png

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. 

Rajesh1093_4-1708679180974.png

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

Rajesh1093_5-1708679286741.png

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

Rajesh1093_6-1708679536574.png

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

Rajesh1093_7-1708680375919.png

 

Happy to help and happy automating 🙂 

 

 

 



 

3 REPLIES 3
yashwant101
Helper I
Helper I

Hi @Rajesh1093,

 

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

yashwant101_0-1712721548127.png

Your help is highly appreciated.

BigJhon
Frequent Visitor

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?

lbendlin
Super User
Super User

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors