cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WaleedBinAfzal
Level: Powered On

How to Send PowerBI Reports Or Screenshot of report via Email

Hi,

I have made some reports in power bi for dynamics 365 online by getting all the data from dynamic 365 online. Now i want to know if there is some way that i can make a flow that will send the screenshot or may be the complete power bi report to specified email addresses?

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to Send PowerBI Reports Or Screenshot of report via Email

Hi @WaleedBinAfzal,

 

If you want to send the screenshot or may be the complete power bi report to specified email addresses, you could consider send the screenshot or the complete power bi report as the attachment of the email.

 

You could save the screenshot or the complete power bi report in a onedrive folder firstly.

 

If you have only one screenshot or the complete power bi report in a onedrive folder, or you have mutiple files in the folder and you want to send each attachment in an email, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

If you have mutiple files in the folder and you want to send all attachments in one email, 

I have made a test on my side to save three files in the folder in onedrive, and you could refer to my screenshot to create the flow to send the three files as attachment of an email as below:

Capture.PNG

Capture.PNG

 

Note: the expression of contentBytes in the Compose as below:

body('Get_file_content')?['$content']

The flow would run successfully to send the email with three attachment as below:

Capture.PNG

 

Capture.PNG

 

 

 

 

Please let me knw if your problem could be solved.

 

 

Best regards,

Alice

 

 

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: How to Send PowerBI Reports Or Screenshot of report via Email

Hi @WaleedBinAfzal,

 

If you want to send the screenshot or may be the complete power bi report to specified email addresses, you could consider send the screenshot or the complete power bi report as the attachment of the email.

 

You could save the screenshot or the complete power bi report in a onedrive folder firstly.

 

If you have only one screenshot or the complete power bi report in a onedrive folder, or you have mutiple files in the folder and you want to send each attachment in an email, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

If you have mutiple files in the folder and you want to send all attachments in one email, 

I have made a test on my side to save three files in the folder in onedrive, and you could refer to my screenshot to create the flow to send the three files as attachment of an email as below:

Capture.PNG

Capture.PNG

 

Note: the expression of contentBytes in the Compose as below:

body('Get_file_content')?['$content']

The flow would run successfully to send the email with three attachment as below:

Capture.PNG

 

Capture.PNG

 

 

 

 

Please let me knw if your problem could be solved.

 

 

Best regards,

Alice

 

 

 

WaleedBinAfzal
Level: Powered On

Re: How to Send PowerBI Reports Or Screenshot of report via Email

Hi Alice,

Thanks for that much detailed answer, it helps me alot. But from this answer i want to ask one more thing from you. How can i store the dynamic 365 report snapshot or dynamic 365 complete report on one drive? Is there any way through which i can automate that process as well? It would be great if you can help me in this regard as well.

 

Thanks.

Highlighted
Community Support Team
Community Support Team

Re: How to Send PowerBI Reports Or Screenshot of report via Email

Hi @WaleedBinAfzal,

 

You could save the files in your computer and then upload the files to your onedrive for business.

 

Best regards,

Alice

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 212 members 4,486 guests
Please welcome our newest community members: